Pandas Profiling Report

Dataset info

Number of variables	96
Number of observations	453
Missing cells	5393 (12.4%)
Duplicate rows	0 (0.0%)
Total size in memory	339.8 KiB
Average record size in memory	768.2 B

Variables types

Numeric	23
Categorical	41
Boolean	7
Date	0
URL	5
Text (Unique)	0
Rejected	20
Unsupported	0

Warnings

`access` has a high cardinality: 228 distinct values	Warning
`access` has 208 (45.9%) missing values	Missing
`amenities` has a high cardinality: 439 distinct values	Warning
`availability_30` has 199 (43.9%) zeros	Zeros
`availability_365` has 79 (17.4%) zeros	Zeros
`availability_60` is highly correlated with `availability_30` (ρ = 0.9201881394)	Rejected
`availability_90` is highly correlated with `availability_60` (ρ = 0.930129306)	Rejected
`bathrooms` has 10 (2.2%) zeros	Zeros
`bathrooms` has 12 (2.6%) missing values	Missing
`bedrooms` has 14 (3.1%) zeros	Zeros
`calendar_last_scraped` has constant value "2018-11-07"	Rejected
`cleaning_fee` has 48 (10.6%) missing values	Missing
`country` has constant value "Germany"	Rejected
`country_code` has constant value "DE"	Rejected
`description` has a high cardinality: 448 distinct values	Warning
`experiences_offered` has constant value "none"	Rejected
`first_review` has a high cardinality: 361 distinct values	Warning
`first_review` has 16 (3.5%) missing values	Missing
`has_availability` has constant value "t"	Rejected
`host_about` has a high cardinality: 367 distinct values	Warning
`host_about` has 11 (2.4%) missing values	Missing
`host_acceptance_rate` has constant value "nan"	Rejected
`host_listings_count` is highly correlated with `calculated_host_listings_count` (ρ = 0.969958062)	Rejected
`host_name` has a high cardinality: 317 distinct values	Warning
`host_response_rate` has 183 (40.4%) missing values	Missing
`host_response_time` has 183 (40.4%) missing values	Missing
`host_since` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`host_since` has a high cardinality: 275 distinct values	Warning
`host_total_listings_count` is highly correlated with `host_listings_count` (ρ = 1)	Rejected
`host_verifications` has a high cardinality: 55 distinct values	Warning
`house_rules` has a high cardinality: 325 distinct values	Warning
`house_rules` has 114 (25.2%) missing values	Missing
`interaction` has a high cardinality: 195 distinct values	Warning
`interaction` has 237 (52.3%) missing values	Missing
`is_business_travel_ready` has constant value "f"	Rejected
`jurisdiction_names` has constant value "nan"	Rejected
`last_review` has a high cardinality: 218 distinct values	Warning
`last_review` has 16 (3.5%) missing values	Missing
`last_scraped` has constant value "2018-11-07"	Rejected
`license` has a high cardinality: 100 distinct values	Warning
`license` has 350 (77.3%) missing values	Missing
`market` has constant value "Berlin"	Rejected
`medium_url` has constant value "nan"	Rejected
`monthly_price` has a high cardinality: 113 distinct values	Warning
`monthly_price` has 195 (43.0%) missing values	Missing
`name` has a high cardinality: 452 distinct values	Warning
`neighborhood_overview` has a high cardinality: 220 distinct values	Warning
`neighborhood_overview` has 211 (46.6%) missing values	Missing
`neighbourhood` has 32 (7.1%) missing values	Missing
`neighbourhood_cleansed` has a high cardinality: 79 distinct values	Warning
`notes` has a high cardinality: 191 distinct values	Warning
`notes` has 243 (53.6%) missing values	Missing
`number_of_reviews` has 16 (3.5%) zeros	Zeros
`price` has a high cardinality: 104 distinct values	Warning
`requires_license` has constant value "t"	Rejected
`review_scores_accuracy` has 19 (4.2%) missing values	Missing
`review_scores_checkin` has 19 (4.2%) missing values	Missing
`review_scores_cleanliness` has 19 (4.2%) missing values	Missing
`review_scores_communication` has 19 (4.2%) missing values	Missing
`review_scores_location` has 19 (4.2%) missing values	Missing
`review_scores_rating` has 19 (4.2%) missing values	Missing
`review_scores_value` has 20 (4.4%) missing values	Missing
`reviews_per_month` is highly correlated with `number_of_reviews` (ρ = 0.9301967298)	Rejected
`scrape_id` has constant value "20181107122246"	Rejected
`security_deposit` has 114 (25.2%) missing values	Missing
`space` has a high cardinality: 435 distinct values	Warning
`space` has 6 (1.3%) missing values	Missing
`square_feet` has 45 (9.9%) zeros	Zeros
`square_feet` has 286 (63.1%) missing values	Missing
`summary` has a high cardinality: 285 distinct values	Warning
`summary` has 156 (34.4%) missing values	Missing
`thumbnail_url` has constant value "nan"	Rejected
`transit` has a high cardinality: 265 distinct values	Warning
`transit` has 164 (36.2%) missing values	Missing
`weekly_price` has a high cardinality: 106 distinct values	Warning
`weekly_price` has 184 (40.6%) missing values	Missing
`xl_picture_url` has constant value "nan"	Rejected
`zipcode` has a high cardinality: 107 distinct values	Warning

access
Categorical

Distinct count	228
Unique (%)	50.3%
Missing (%)	45.9%
Missing (n)	208

In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room.	9
Ihr habt eine ganze Wohnung für Euch.	3
There is two good bathrooms in the apartment. For your personal convenience while staying here I'm offering a selection of skincare products in both bathrooms. The kitchen is well equipped and there is good space to do some lightly cooking, sit and enjoy your meal, maybe work or use the internet. There is of course a fridge with freezer, where you can store your food and a microwave oven if you want to heat food. I also offer a variety of tea and coffees during your stay. Further offers are; hair-dryer, iron and ironing board and of course wireless/WiFi Internet. There is also a desk in each room.	2
Other values (224)	231
(Missing)	208

Toggle details

Common values
Composition

Value	Count	Frequency (%)
In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room.	9	2.0%
Ihr habt eine ganze Wohnung für Euch.	3	0.7%
There is two good bathrooms in the apartment. For your personal convenience while staying here I'm offering a selection of skincare products in both bathrooms. The kitchen is well equipped and there is good space to do some lightly cooking, sit and enjoy your meal, maybe work or use the internet. There is of course a fridge with freezer, where you can store your food and a microwave oven if you want to heat food. I also offer a variety of tea and coffees during your stay. Further offers are; hair-dryer, iron and ironing board and of course wireless/WiFi Internet. There is also a desk in each room.	2	0.4%
As our guest you will have the whole apartment to yourself. You won’t have to share it with anybody else. You may also use the courtyard to store your bicycle.	2	0.4%
Sie mieten die gesamte Wohnung. Niemand anderes hat Zugang.	2	0.4%
Included in the price are fresh sheets and towels, the common use of the bathroom, guest toilet, kitchen and living room as well as the internet acccess.	2	0.4%
Fri Parkering & Internet Mycket nära till det mesta	2	0.4%
das große Grundstück 1400 m² erwartet Sie mit einer 18 Meter breiten Wasserfläche an der Sie Sich sonnen können und auch direkt am Wasser Ihre Mahlzeiten einnehmen können, oder eine Drink mit dem Blick auf dem Seddinsee genießen können	2	0.4%
Bright and clean shared bathroom with shower. No kitchen!	2	0.4%
The apartment is ideal for 2 adults and a maximum of 2 children.	2	0.4%
Other values (217)	217	47.9%
(Missing)	208	45.9%

Max length	1000
Mean length	93.09050773
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

accommodates
Numeric

Distinct count	12
Unique (%)	2.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.112582781
Minimum	1
Maximum	15
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	2
Q3	4
95-th percentile	6
Maximum	15
Range	14
Interquartile range	2

Descriptive statistics

Standard deviation	1.788148223
Coef of variation	0.5744901737
Kurtosis	8.574939951
Mean	3.112582781
MAD	1.347952575
Skewness	2.189810225
Sum	1410
Variance	3.197474067
Memory size	3.6 KiB

Histogram with fixed size bins (bins=12)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 6.5 9. 15. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	207	45.7%
4	96	21.2%
3	47	10.4%
1	33	7.3%
5	31	6.8%
6	24	5.3%
8	8	1.8%
10	2	0.4%
7	2	0.4%
15	1	0.2%
Other values (2)	2	0.4%

Minimum 5 values

Value	Count	Frequency (%)
1	33	7.3%
2	207	45.7%
3	47	10.4%
4	96	21.2%
5	31	6.8%

Maximum 5 values

Value	Count	Frequency (%)
15	1	0.2%
14	1	0.2%
12	1	0.2%
10	2	0.4%
8	8	1.8%

amenities
Categorical

Distinct count	439
Unique (%)	96.9%
Missing (%)	0.0%
Missing (n)	0

{Internet,Wifi,Kitchen,Heating,"Family/kid friendly","Lock on bedroom door",Hangers,"Hot water"}	3
{Internet,Wifi,Heating}	2
{TV,Internet,Wifi,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Bed linens","Host greets you"}	2
Other values (436)	446

Toggle details

Common values
Composition

Value	Count	Frequency (%)
{Internet,Wifi,Kitchen,Heating,"Family/kid friendly","Lock on bedroom door",Hangers,"Hot water"}	3	0.7%
{Internet,Wifi,Heating}	2	0.4%
{TV,Internet,Wifi,Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Bed linens","Host greets you"}	2	0.4%
{}	2	0.4%
{TV,Internet,Wifi,"Paid parking off premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Bed linens","Host greets you"}	2	0.4%
{TV,"Cable TV",Internet,Wifi,Kitchen,"Free street parking",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance","Hot water","Bed linens","Host greets you"}	2	0.4%
{TV,"Cable TV",Internet,Wifi,Kitchen,Heating,"Family/kid friendly"}	2	0.4%
{TV,Internet,Wifi,Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Essentials,Hangers,"Hair dryer","Laptop friendly workspace"}	2	0.4%
{TV,Internet,Wifi,"Paid parking off premises",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card","Fire extinguisher",Essentials,"Hair dryer",Iron,"Host greets you"}	2	0.4%
{TV,"Cable TV",Internet,Wifi,Kitchen,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer}	2	0.4%
Other values (429)	432	95.4%

Max length	1006
Mean length	301.8366446
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

availability_30
Numeric

Distinct count	31
Unique (%)	6.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.300220751
Minimum	0
Maximum	30
Zeros (%)	43.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	3
Q3	13
95-th percentile	28
Maximum	30
Range	30
Interquartile range	13

Descriptive statistics

Standard deviation	9.289251803
Coef of variation	1.272461768
Kurtosis	-0.04082647183
Mean	7.300220751
MAD	7.6850528
Skewness	1.113316295
Sum	3307
Variance	86.29019907
Memory size	3.6 KiB

Histogram with fixed size bins (bins=31)

Histogram with variable size bins (bins=[ 0. 0.5 9.5 29.5 30. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	199	43.9%
6	26	5.7%
1	13	2.9%
3	13	2.9%
8	13	2.9%
5	12	2.6%
9	11	2.4%
29	10	2.2%
2	10	2.2%
4	10	2.2%
Other values (21)	136	30.0%

Minimum 5 values

Value	Count	Frequency (%)
0	199	43.9%
1	13	2.9%
2	10	2.2%
3	13	2.9%
4	10	2.2%

Maximum 5 values

Value	Count	Frequency (%)
30	10	2.2%
29	10	2.2%
28	4	0.9%
27	8	1.8%
26	3	0.7%

availability_365
Numeric

Distinct count	205
Unique (%)	45.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	174.8300221
Minimum	0
Maximum	365
Zeros (%)	17.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	32
Median	191
Q3	302
95-th percentile	352
Maximum	365
Range	365
Interquartile range	270

Descriptive statistics

Standard deviation	130.2403998
Coef of variation	0.7449544323
Kurtosis	-1.541630299
Mean	174.8300221
MAD	118.648763
Skewness	-0.1015411187
Sum	79198
Variance	16962.56175
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 5.5 242.5 365. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	79	17.4%
352	6	1.3%
159	6	1.3%
310	6	1.3%
129	5	1.1%
275	5	1.1%
311	5	1.1%
341	5	1.1%
365	5	1.1%
211	4	0.9%
Other values (195)	327	72.2%

Minimum 5 values

Value	Count	Frequency (%)
0	79	17.4%
1	4	0.9%
2	1	0.2%
3	4	0.9%
4	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
365	5	1.1%
364	2	0.4%
363	2	0.4%
362	4	0.9%
361	1	0.2%

availability_60
Highly correlated

This variable is highly correlated with availability_30 and should be ignored for analysis

Correlation	0.9201881394

availability_90
Highly correlated

This variable is highly correlated with availability_60 and should be ignored for analysis

Correlation	0.930129306

bathrooms
Numeric

Distinct count	8
Unique (%)	1.8%
Missing (%)	2.6%
Missing (n)	12
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.10430839
Minimum	0
Maximum	5
Zeros (%)	2.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range	0

Descriptive statistics

Standard deviation	0.4078820408
Coef of variation	0.3693551951
Kurtosis	21.11016162
Mean	1.10430839
MAD	0.2273795384
Skewness	2.904984804
Sum	487
Variance	0.1663677592
Memory size	3.6 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	369	81.5%
2	33	7.3%
1.5	21	4.6%
0	10	2.2%
2.5	6	1.3%
5	1	0.2%
0.5	1	0.2%
(Missing)	12	2.6%

Minimum 5 values

Value	Count	Frequency (%)
0	10	2.2%
0.5	1	0.2%
1	369	81.5%
1.5	21	4.6%
2	33	7.3%

Maximum 5 values

Value	Count	Frequency (%)
5	1	0.2%
2.5	6	1.3%
2	33	7.3%
1.5	21	4.6%
1	369	81.5%

bed_type
Categorical

Distinct count	4
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

Real Bed	433
Pull-out Sofa	12
Futon	7

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Real Bed	433	95.6%
Pull-out Sofa	12	2.6%
Futon	7	1.5%
Couch	1	0.2%

Max length	13
Mean length	8.079470199
Min length	5
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

bedrooms
Numeric

Distinct count	8
Unique (%)	1.8%
Missing (%)	0.2%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.28539823
Minimum	0
Maximum	8
Zeros (%)	3.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range	0

Descriptive statistics

Standard deviation	0.7050398682
Coef of variation	0.5484991746
Kurtosis	20.51870207
Mean	1.28539823
MAD	0.4913070718
Skewness	3.117379818
Sum	581
Variance	0.4970812158
Memory size	3.6 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	326	72.0%
2	91	20.1%
3	16	3.5%
0	14	3.1%
4	3	0.7%
8	1	0.2%
5	1	0.2%
(Missing)	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
0	14	3.1%
1	326	72.0%
2	91	20.1%
3	16	3.5%
4	3	0.7%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.2%
5	1	0.2%
4	3	0.7%
3	16	3.5%
2	91	20.1%

beds
Numeric

Distinct count	12
Unique (%)	2.6%
Missing (%)	0.2%
Missing (n)	1
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.134955752
Minimum	0
Maximum	15
Zeros (%)	0.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
Median	2
Q3	3
95-th percentile	5
Maximum	15
Range	15
Interquartile range	2

Descriptive statistics

Standard deviation	1.708701935
Coef of variation	0.8003453625
Kurtosis	15.33834238
Mean	2.134955752
MAD	1.135464798
Skewness	3.061941344
Sum	965
Variance	2.919662304
Memory size	3.6 KiB

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	209	46.1%
2	128	28.3%
3	48	10.6%
4	28	6.2%
5	17	3.8%
6	12	2.6%
8	5	1.1%
15	2	0.4%
10	1	0.2%
0	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.2%
1	209	46.1%
2	128	28.3%
3	48	10.6%
4	28	6.2%

Maximum 5 values

Value	Count	Frequency (%)
15	2	0.4%
10	1	0.2%
8	5	1.1%
7	1	0.2%
6	12	2.6%

calculated_host_listings_count
Numeric

Distinct count	11
Unique (%)	2.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.105960265
Minimum	1
Maximum	14
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	6
Maximum	14
Range	13
Interquartile range	1

Descriptive statistics

Standard deviation	2.396953222
Coef of variation	1.138175901
Kurtosis	12.99339721
Mean	2.105960265
MAD	1.376723243
Skewness	3.506092283
Sum	954
Variance	5.745384751
Memory size	3.6 KiB

Histogram with fixed size bins (bins=11)

Histogram with variable size bins (bins=[ 1. 1.5 2.5 4.5 14. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	274	60.5%
2	83	18.3%
3	43	9.5%
4	27	6.0%
14	9	2.0%
11	5	1.1%
10	5	1.1%
6	3	0.7%
7	2	0.4%
9	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
1	274	60.5%
2	83	18.3%
3	43	9.5%
4	27	6.0%
5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
14	9	2.0%
11	5	1.1%
10	5	1.1%
9	1	0.2%
7	2	0.4%

calendar_last_scraped
Constant

This variable is constant and should be ignored for analysis

Constant value	2018-11-07

calendar_updated
Categorical

Distinct count	42
Unique (%)	9.3%
Missing (%)	0.0%
Missing (n)	0

today	105
a week ago	34
2 months ago	32
Other values (39)	282

Toggle details

Common values
Composition

Value	Count	Frequency (%)
today	105	23.2%
a week ago	34	7.5%
2 months ago	32	7.1%
2 weeks ago	29	6.4%
yesterday	27	6.0%
3 weeks ago	26	5.7%
3 months ago	19	4.2%
3 days ago	16	3.5%
4 months ago	16	3.5%
5 weeks ago	14	3.1%
Other values (32)	135	29.8%

Max length	13
Mean length	9.626931567
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

cancellation_policy
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

strict_14_with_grace_period	255
moderate	147
flexible	51

Toggle details

Common values
Composition

Value	Count	Frequency (%)
strict_14_with_grace_period	255	56.3%
moderate	147	32.5%
flexible	51	11.3%

Max length	27
Mean length	18.69536424
Min length	8
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

city
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

Berlin	451
Schöneberg	1
Berlin (Kreuzberg)	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin	451	99.6%
Schöneberg	1	0.2%
Berlin (Kreuzberg)	1	0.2%

Max length	18
Mean length	6.035320088
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

cleaning_fee
Categorical

Distinct count	47
Unique (%)	10.4%
Missing (%)	10.6%
Missing (n)	48

$30.00	60
$50.00	44
$20.00	39
Other values (43)	262
(Missing)	48

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$30.00	60	13.2%
$50.00	44	9.7%
$20.00	39	8.6%
$0.00	37	8.2%
$40.00	37	8.2%
$35.00	28	6.2%
$25.00	24	5.3%
$15.00	22	4.9%
$60.00	18	4.0%
$10.00	11	2.4%
Other values (36)	85	18.8%
(Missing)	48	10.6%

Max length	7
Mean length	5.620309051
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

country
Constant

This variable is constant and should be ignored for analysis

Constant value	Germany

country_code
Constant

This variable is constant and should be ignored for analysis

Constant value	DE

description
Categorical

Distinct count	448
Unique (%)	98.9%
Missing (%)	0.2%
Missing (n)	1

The accommodation is located in the district of Neukölln, in the middle of the old Bohemian Rixdorf, a historical working class quarter that was once founded in 1737. Berlin-Neukölln offers many cafés, bars and shopping opportunities, international cultural offerings such as the Neukölln opera, movies, numerous galleries as well as the Volkspark Hasenheide are within walking distance. We offer single, double, 3 beds rooms and a holiday home. There are 2 shared bathrooms and a small kitchen available for the rooms. They are also suitable for small groups of up to 10 persons. The holiday apartment is suitable for up to 4 persons and is situated on the 2nd floor. It has 1 room with TV, bathroom, kitchen and a washing machine. Berlin offers many opportunities to experience both historical & modern culture and space to relax. The growing together of East and West can be intensely experienced in Berlin, in particular. Among the most attracting sights you find the historical city center with	2
Exceptional guestroom in the back of the legendary Berlin Kinomuseum. We offer one single and one double room, regulary Salon Evenings and Film Screenings. Truly unique in Berlin! Bright and clean shared bathroom with shower. No kitchen! U8 Schönleinstraße No place for party people!	2
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	2
Other values (444)	446

Toggle details

Common values
Composition

Value	Count	Frequency (%)
The accommodation is located in the district of Neukölln, in the middle of the old Bohemian Rixdorf, a historical working class quarter that was once founded in 1737. Berlin-Neukölln offers many cafés, bars and shopping opportunities, international cultural offerings such as the Neukölln opera, movies, numerous galleries as well as the Volkspark Hasenheide are within walking distance. We offer single, double, 3 beds rooms and a holiday home. There are 2 shared bathrooms and a small kitchen available for the rooms. They are also suitable for small groups of up to 10 persons. The holiday apartment is suitable for up to 4 persons and is situated on the 2nd floor. It has 1 room with TV, bathroom, kitchen and a washing machine. Berlin offers many opportunities to experience both historical & modern culture and space to relax. The growing together of East and West can be intensely experienced in Berlin, in particular. Among the most attracting sights you find the historical city center with	2	0.4%
Exceptional guestroom in the back of the legendary Berlin Kinomuseum. We offer one single and one double room, regulary Salon Evenings and Film Screenings. Truly unique in Berlin! Bright and clean shared bathroom with shower. No kitchen! U8 Schönleinstraße No place for party people!	2	0.4%
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	2	0.4%
Large room that can accommodate up to 6 people. It has 3 bunk beds and is very suitable for small groups. The spacious bathroom is for multiple rooms. Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes! In addition to bedding and free towels, there are washers, dryers, TV and also free Wi-Fi available in the common room. You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel. Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries	2	0.4%
Lovely Apartment for two persons. Nice and sunny reasonable Apartment, 35 qm, modernized, quietly, traffic favourable.	2	0.4%
I offer a small and cozy room in a 4-room apartment with a nice funky Family :) The apartment is very conveniently located, providing an extremely convenient transport links by bus and train and very good shopping. In the immediate vicinity are the citizens Pankow and Farm "Pinke-Panke, numerous restaurants and cafes that invite to the palate. The closest train station is the Wollankstrasse, of which one arrives in a few minutes to the many sights of Berlin. On foot you can easily get to Pankow with Castle Niederschönhausen or in the trendy Prenzlauer Berg district, with its varied offerings.'s home is the use of wireless internet available to our guests . The apartment is generally very colorful painted and stylish decorated, which gives a very warm and friendly atmosphere. The guest room offers perfect space for one person and has a comfortable bed, a dresser and a variety of decorations and a cozy sitting area with views over the rooftops of Berlin. This room is located at the ent	1	0.2%
Storage Berlin - Contemporary and innovative lodging & locationservice for film, photo & advertising in the heart of Berlin! A lot of space in this sunny studio for your production & your team or friends! Feel home as in your own one! Rent one of the rooms as single traveller or accommodate a whole bunch of people! Shared commons include fully equipped kitchen, 2 large and modern bathrooms, a meet´n´greet and dining area with wooden table and a large lounge with free wlan access. Completed in 1913, the building that houses this Berlin loft apartment started life as a printing factory. Today, the stunning fourth floor loft, which retains some of the quainter industrial features such as exposed brickwork, and incorporates found and hand-crafted items, is a uniquely renovated urban environment for short stay visitors and film shoots. A beautiful example of Berlin’s growing trend for factory and warehouse conversions, the apartment is an impressive 280 sqm and sleeps up to 10 people in fi	1	0.2%
Hey there, I'm renting out my room in the center of lovely and beautiful neighboorhood Prenzlauerberg, where you find nice cafes and boutiques, restaurants et al. Relax over here for your adventures in the city The place got a warm nice feel. I made some of furniture myself with plywood, some stuff is just older from my family, but I think the pictures are doing the job better than words. You have your own bedroom to yourself and access to a big living room which is shared with my friendly roommate. Kitchen and Bathroom are shared areas aswell. I'm renting out my private room , so I won't be around for that time. You will be able to pick up the keys close by and find little welcome note in the house. If there's an essential question you can reach me via mail or phone. The neighbourhood is mainly residential but offering a lot of different threads, from nice little cafes and high quality cocktail bars. There are a lot of parks close by, flea markets, little boutiques, plenty organic sup	1	0.2%
–One double bed (Bedclothes incl.) –Shower, towels and hairdryer. –WLAN –Kitchen: washing machine, drying rack and dishwhaser –One double bed (Bedclothes incl.) –Shower, towels and hairdryer. –WLAN –washing machine, drying rack and dishwhaser H O T T I P!!!: Markthalle neun.(foto) Every Thursday (17-22 hours) STREET FOOD, Tuesday, Friday and Saturday (10-18 hours) WOCHENMARKT. Very sunny bedroom with one bed for two people (BEDSHEETS are included), kitchen and bathroom with SHOWER (TOWELS incl.),which is located in the lively district of Kreuzberg SO36 with many cafes, restaurants and bars around. The sightseeing attractions East Side Gallery (Berlin Wall) and Oberbaumbrücke are close-by. The metro stations Görlitzer Bahnhof and Schlesisches Tor U1 are just 5min walking distance away. The Ostbahnhof railway station is very easy to reach, and there is a bus (the 165/265 every 10 minutes) outside the front door. Carpark ist no problem in the street. The house (1890) is very quiet and	1	0.2%
Hi we love art and we love Berlin. Do not forget that at certain times of the year we can offer great prices. 2 persone 1100€ at Month +% sito web. Hello we present ourselves Gaston and Helen, we love art and we love Berlin. If you have any questions or concerns do not hesitate to contact us, it will be my pleasure to answer your questions. Do not forget that at certain times of the year we can offer great prices weekly. Do not stop at what the site automatically calculates, because sometimes the total price becomes too much more if you book for several days. After a certain number of days we apply the discounts. So you have to ask, you do not stop at what the site says. We are pleased to remind you that we are here at your disposal to answer any of your questions. On request access Wi-Fi. The price is inclusive of 5% for the tax. The 40m2 apartment is very quiet, newly renovated, overlooking the courtyard of the building that is bright and south facing and has light and sun a	1	0.2%
Other values (437)	437	96.5%

Max length	1000
Mean length	923.0242826
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

experiences_offered
Constant

This variable is constant and should be ignored for analysis

Constant value	none

extra_people
Categorical

Distinct count	32
Unique (%)	7.1%
Missing (%)	0.0%
Missing (n)	0

$0.00	96
$10.00	83
$20.00	56
Other values (29)	218

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$0.00	96	21.2%
$10.00	83	18.3%
$20.00	56	12.4%
$15.00	55	12.1%
$25.00	27	6.0%
$5.00	23	5.1%
$30.00	16	3.5%
$12.00	15	3.3%
$18.00	12	2.6%
$19.00	7	1.5%
Other values (22)	63	13.9%

Max length	7
Mean length	5.706401766
Min length	5
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

first_review
Categorical

Distinct count	361
Unique (%)	79.7%
Missing (%)	3.5%
Missing (n)	16

2012-06-26	4
2012-07-23	4
2012-01-04	4
Other values (357)	425
(Missing)	16

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2012-06-26	4	0.9%
2012-07-23	4	0.9%
2012-01-04	4	0.9%
2012-05-01	4	0.9%
2012-06-04	3	0.7%
2012-08-16	3	0.7%
2012-04-07	3	0.7%
2010-09-16	3	0.7%
2012-01-06	3	0.7%
2011-07-18	3	0.7%
Other values (350)	403	89.0%
(Missing)	16	3.5%

Max length	10
Mean length	9.752759382
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

guests_included
Numeric

Distinct count	7
Unique (%)	1.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.589403974
Minimum	1
Maximum	8
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	3
Maximum	8
Range	7
Interquartile range	1

Descriptive statistics

Standard deviation	0.8513772537
Coef of variation	0.5356581888
Kurtosis	10.77773535
Mean	1.589403974
MAD	0.6453518121
Skewness	2.538407777
Sum	720
Variance	0.724843228
Memory size	3.6 KiB

Histogram with fixed size bins (bins=7)

Histogram with variable size bins (bins=[1. 1.5 2.5 4.5 8. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	248	54.7%
2	173	38.2%
4	17	3.8%
3	11	2.4%
6	2	0.4%
8	1	0.2%
5	1	0.2%

Minimum 5 values

Value	Count	Frequency (%)
1	248	54.7%
2	173	38.2%
3	11	2.4%
4	17	3.8%
5	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
8	1	0.2%
6	2	0.4%
5	1	0.2%
4	17	3.8%
3	11	2.4%

has_availability
Constant

This variable is constant and should be ignored for analysis

Constant value	t

host_about
Categorical

Distinct count	367
Unique (%)	81.0%
Missing (%)	2.4%
Missing (n)	11

Hallo, wir freuen uns sehr auf freundliche Gäste aus aller Welt und begrüßen Euch ganz herzlich! Im Sunflower Hostel stehen euch gemischte Mehrbettzimmer und geschlechtergetrennte Gemeinschaftsbäder zur Verfügung. Des Weiteren erwarten euch freundliches Personal, die weltweit größte Outdoor-Raucher-Lounge und eine 23h-Bar. Für eure Wünsche und Fragen haben wir rund um die Uhr ein offenes Ohr und helfen euch gern weiter mit Empfehlungen, Wegbeschreibungen etc. Wir freuen uns auf Eure Anfragen! Euer Sunflower-Team	9
Herzlich willkommen in meiner Unterkunft in Berlin Neukölln Ich würde mich freuen, wenn Ihr Euch für meine Wohnung entscheidet und stehe Euch gerne mit Tipps zur Seite.	5
Ich habe mit der Eröffnung der Ferienwohnung in Berlin Heiligensee schon 2004 angefangen - das Ferienhaus Dressler am Wasser und die Ferienwohnung am Wasser kamen 2010 hinzu .Viele zufriedene Gäste haben sich in diesen Jahren wie zuhause gefühlt - wann kommen Si (Website hidden by Airbnb) unter (Website hidden by Airbnb) gibt es alle schönen Bilder	4
Other values (363)	424
(Missing)	11

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Hallo, wir freuen uns sehr auf freundliche Gäste aus aller Welt und begrüßen Euch ganz herzlich! Im Sunflower Hostel stehen euch gemischte Mehrbettzimmer und geschlechtergetrennte Gemeinschaftsbäder zur Verfügung. Des Weiteren erwarten euch freundliches Personal, die weltweit größte Outdoor-Raucher-Lounge und eine 23h-Bar. Für eure Wünsche und Fragen haben wir rund um die Uhr ein offenes Ohr und helfen euch gern weiter mit Empfehlungen, Wegbeschreibungen etc. Wir freuen uns auf Eure Anfragen! Euer Sunflower-Team	9	2.0%
Herzlich willkommen in meiner Unterkunft in Berlin Neukölln Ich würde mich freuen, wenn Ihr Euch für meine Wohnung entscheidet und stehe Euch gerne mit Tipps zur Seite.	5	1.1%
Ich habe mit der Eröffnung der Ferienwohnung in Berlin Heiligensee schon 2004 angefangen - das Ferienhaus Dressler am Wasser und die Ferienwohnung am Wasser kamen 2010 hinzu .Viele zufriedene Gäste haben sich in diesen Jahren wie zuhause gefühlt - wann kommen Si (Website hidden by Airbnb) unter (Website hidden by Airbnb) gibt es alle schönen Bilder	4	0.9%
Hallo zusammen, mein Name ist Joe! Ich freue mich über viele nette Gäste aus aller Welt.	4	0.9%
Ich heiße alle Gäste , die die meine aufregende Stadt Berlin kennen lernen wollen herzlich willkommen. Nach dem Motto : immer leben und leben lassen bin ich gerne Gastgeberin für fast alle Menschen aus aller Welt, von nah und fern. Bei mir soll man sich wohl fühlen und wiederkommen.	4	0.9%
Sehr geehrte Gäste, Einen schönen Guten Tag ! Wir sind Bernd und Tamara. Unsere Sprachen sind Deutsch , Englisch, Russisch und wir freuen uns darauf, Sie bei uns in Berlin begrüssen zu dürfen. Bei uns werden Sie sich wohlfühlen! Dear Guests, Greetings to you from Berlin ! We are Bernd and Tamara. Our languages are German and English, and we are looking forward to having you as our guests here in Berlin ! We are certain that you will enjoy your stay with us ! Profil of Bernd: Born 1940 in Königsberg/East Prussia, - Territory now belonging to Russia. - At age 4, family escaped to the former East Germany. After Public School: Professional Letter as Factory Mechanic. Refusal of East German Government to my entering College, because of Membership at Protestant Church-Youth Organization, where I sang in a Church-Choir and played the Trompet at Church-Functions. Age 16 !!: Coal Miner in a Brown-Coal Pit !!! "Move" !!! (officially denounced and documented as illegal) to the former West Germany. - In Wiesbaden: Professional Letter as Machine Draftsman, and Work as Machine Designer in the Field of Chemical-Process-Machines. 1968 in New York City: Machine Designer and Student at New York City College: Bachelor of Arts in 1972. Major Direction of Study: Psychology, Minor: German Literature. At the Caribbean Island-State of St. Kitts-Nevis/West Indies (Leeward Islands): Lecturer of Technical Drawing at the Technical College in St. Kitts/West Indies, and Math-Teacher at Gingerland High-School in Nevis/West Indies, having taught in the British O-Level System. - In St. Kitts: the Founding of a Chess-Club, meeting once a week ! (It still was functioning 10 years later) (Website hidden by Airbnb) The Date of Independance from Britain is the 19th of September, which also is my Birthday ! In 1976, back to the U.S., to Chicago: Real Estate Salesman & Manager. Work with Procter & Gamble. Purchase and Sale of vacant, - old and broken-down Buildings. Restauration of those Buildings. Rental of their Apartments after Re-Hab. (To be continued).	4	0.9%
Hey wir, Wolfgang und Ute Lehnert, freuen uns auf nette Gäste aus der ganzen Welt. Wir sind froh unsere Kultur und Sehenswürdigkeiten mit anderen teilen zu können.	4	0.9%
We are a laid back Irish-Polish/German couple. We moved to Berlin about six years ago and are really loving it here. It's an amazing city and we are looking forward to sharing our favourite Berlin spots with you. We have prepared an extensive guide book for all our guests with many tips on what to do in Berlin, where to eat and where to go out in the evening. It also has a section for parents and tips for the winter and for the summer. We are looking forward to hosting you in our apartments!	4	0.9%
ich bin eigentlich diplomierter Stadt- und Regionalplaner. Ein bürokratischer, eintöniger Büroalltag liegt mir aber nicht. Also arbeite ich als Gästebetreuer und Fahrdienstleiter im Showbiz und heiße Gäste in meinen zwei Ferienwohnungen willkommen. Ich repräsentiere meine Stadt mit Hingabe.	3	0.7%
Ich bin hilfsbereit, gastfreundlich und freue mich immer wieder neue und interessante Leute aus der ganzen Welt kennenzulernen.	3	0.7%
Other values (356)	398	87.9%
(Missing)	11	2.4%

Max length	2113
Mean length	283.4834437
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

host_acceptance_rate
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

host_has_profile_pic
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

t	452
f	1

Toggle details

Value	Count	Frequency (%)
t	452	99.8%
f	1	0.2%

host_id
Numeric

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1063003.311
Minimum	2217
Maximum	4059665
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2217
5-th percentile	98237
Q1	611847
Median	1152791
Q3	1409188
95-th percentile	2040642.6
Maximum	4059665
Range	4057448
Interquartile range	797341

Descriptive statistics

Standard deviation	603446.6401
Coef of variation	0.5676808658
Kurtosis	0.5049375493
Mean	1063003.311
MAD	493770.993
Skewness	0.2487864693
Sum	481540500
Variance	3.641478474e+11
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[2.2170000e+03 3.1402700e+05 8.0605500e+05 9.8112300e+05 1.1951010e+06 ... 1.3916585e+06 1.3933665e+06 1.6802285e+06 2.2808840e+06 4.0596650e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1391772	9	2.0%
1654885	5	1.1%
833995	4	0.9%
163384	4	0.9%
898681	4	0.9%
1311309	4	0.9%
1282150	4	0.9%
1310755	4	0.9%
1371414	3	0.7%
1473320	3	0.7%
Other values (371)	409	90.3%

Minimum 5 values

Value	Count	Frequency (%)
2217	1	0.2%
2986	1	0.2%
3718	1	0.2%
4108	1	0.2%
17391	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
4059665	1	0.2%
3062473	1	0.2%
2281237	1	0.2%
2280531	1	0.2%
2271792	1	0.2%

host_identity_verified
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	240
t	213

Toggle details

Value	Count	Frequency (%)
f	240	53.0%
t	213	47.0%

host_is_superhost
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	347
t	106

Toggle details

Value	Count	Frequency (%)
f	347	76.6%
t	106	23.4%

host_listings_count
Highly correlated

This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis

Correlation	0.969958062

host_location
Categorical

Distinct count	33
Unique (%)	7.3%
Missing (%)	0.0%
Missing (n)	0

Berlin, Berlin, Germany	410
Germany	4
DE	4
Other values (30)	35

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin, Berlin, Germany	410	90.5%
Germany	4	0.9%
DE	4	0.9%
Munich, Bayern, Germany	3	0.7%
Plombières, Walloon Region, Belgium	2	0.4%
Santa Cruz, California, United States	2	0.4%
Ibiza, Balearic Islands, Spain	2	0.4%
Athens, Attica, Greece	1	0.2%
Key Biscayne, Florida, United States	1	0.2%
Leipzig, Saxony, Germany	1	0.2%
Other values (23)	23	5.1%

Max length	55
Mean length	23.11479029
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_name
Categorical

Distinct count	317
Unique (%)	70.0%
Missing (%)	0.0%
Missing (n)	0

Sunflower Hostel	9
Michael	6
Peter	6
Other values (314)	432

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Sunflower Hostel	9	2.0%
Michael	6	1.3%
Peter	6	1.3%
Bernd	6	1.3%
Frank	5	1.1%
Wolfram	5	1.1%
Ursula	5	1.1%
Claudius	5	1.1%
Alan & Kasia	4	0.9%
Thomas	4	0.9%
Other values (307)	398	87.9%

Max length	22
Mean length	6.536423841
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_neighbourhood
Categorical

Distinct count	49
Unique (%)	10.8%
Missing (%)	0.0%
Missing (n)	0

Prenzlauer Berg	88
Mitte	65
Kreuzberg	58
Other values (46)	242

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Prenzlauer Berg	88	19.4%
Mitte	65	14.3%
Kreuzberg	58	12.8%
Friedrichshain	47	10.4%
Neukölln	34	7.5%
Schöneberg	31	6.8%
Charlottenburg	27	6.0%
Moabit	11	2.4%
Wilmersdorf	9	2.0%
Wedding	7	1.5%
Other values (39)	76	16.8%

Max length	17
Mean length	10.47019868
Min length	5
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_picture_url
URL

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://a0.muscache.com/im/users/1391772/profile_pic/1399369623/original.jpg?aki_policy=profile_x_medium	9	2.0%
https://a0.muscache.com/im/users/1654885/profile_pic/1428655180/original.jpg?aki_policy=profile_x_medium	5	1.1%
https://a0.muscache.com/im/users/833995/profile_pic/1311108238/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/163384/profile_pic/1284286874/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/898681/profile_pic/1391541551/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1282150/profile_pic/1390041405/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1310755/profile_pic/1319620911/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1311309/profile_pic/1319105126/original.jpg?aki_policy=profile_x_medium	4	0.9%
https://a0.muscache.com/im/users/1371414/profile_pic/1320450499/original.jpg?aki_policy=profile_x_medium	3	0.7%
https://a0.muscache.com/im/users/1473320/profile_pic/1323093790/original.jpg?aki_policy=profile_x_medium	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
a0.muscache.com	453	100.0%

Value	Count	Frequency (%)
/im/users/1391772/profile_pic/1399369623/original.jpg	9	2.0%
/im/users/1654885/profile_pic/1428655180/original.jpg	5	1.1%
/im/users/163384/profile_pic/1284286874/original.jpg	4	0.9%
/im/users/1310755/profile_pic/1319620911/original.jpg	4	0.9%
/im/users/833995/profile_pic/1311108238/original.jpg	4	0.9%
/im/users/1311309/profile_pic/1319105126/original.jpg	4	0.9%
/im/users/898681/profile_pic/1391541551/original.jpg	4	0.9%
/im/users/1282150/profile_pic/1390041405/original.jpg	4	0.9%
/im/users/253136/profile_pic/1331586983/original.jpg	3	0.7%
/im/users/1848347/profile_pic/1330987898/original.jpg	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
aki_policy=profile_x_medium	452	99.8%
v=3	1	0.2%

Value	Count	Frequency (%)
	453	100.0%

host_response_rate
Categorical

Distinct count	22
Unique (%)	4.9%
Missing (%)	40.4%
Missing (n)	183

100%	213
90%	13
86%	7
Other values (18)	37
(Missing)	183

Toggle details

Common values
Composition

Value	Count	Frequency (%)
100%	213	47.0%
90%	13	2.9%
86%	7	1.5%
50%	6	1.3%
80%	5	1.1%
75%	4	0.9%
96%	3	0.7%
0%	3	0.7%
67%	2	0.4%
88%	2	0.4%
Other values (11)	12	2.6%
(Missing)	183	40.4%

Max length	4
Mean length	3.463576159
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

host_response_time
Categorical

Distinct count	5
Unique (%)	1.1%
Missing (%)	40.4%
Missing (n)	183

within an hour	118
within a few hours	78
within a day	68
(Missing)	183

Toggle details

Common values
Composition

Value	Count	Frequency (%)
within an hour	118	26.0%
within a few hours	78	17.2%
within a day	68	15.0%
a few days or more	6	1.3%
(Missing)	183	40.4%

Max length	18
Mean length	9.997792494
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

host_since
Categorical

Distinct count	275
Unique (%)	60.7%
Missing (%)	0.0%
Missing (n)	0

2011-10-19	14
2011-11-10	10
2012-01-26	7
Other values (272)	422

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2011-10-19	14	3.1%
2011-11-10	10	2.2%
2012-01-26	7	1.5%
2011-10-11	7	1.5%
2011-07-18	5	1.1%
2011-10-14	5	1.1%
2011-10-24	5	1.1%
2011-09-22	5	1.1%
2011-10-31	5	1.1%
2011-07-31	5	1.1%
Other values (265)	385	85.0%

Max length	10
Mean length	10
Min length	10
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

host_thumbnail_url
URL

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://a0.muscache.com/im/users/1391772/profile_pic/1399369623/original.jpg?aki_policy=profile_small	9	2.0%
https://a0.muscache.com/im/users/1654885/profile_pic/1428655180/original.jpg?aki_policy=profile_small	5	1.1%
https://a0.muscache.com/im/users/1310755/profile_pic/1319620911/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/898681/profile_pic/1391541551/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/163384/profile_pic/1284286874/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/1282150/profile_pic/1390041405/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/1311309/profile_pic/1319105126/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/833995/profile_pic/1311108238/original.jpg?aki_policy=profile_small	4	0.9%
https://a0.muscache.com/im/users/1848347/profile_pic/1330987898/original.jpg?aki_policy=profile_small	3	0.7%
https://a0.muscache.com/im/users/1968246/profile_pic/1332173070/original.jpg?aki_policy=profile_small	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
a0.muscache.com	453	100.0%

Value	Count	Frequency (%)
/im/users/1391772/profile_pic/1399369623/original.jpg	9	2.0%
/im/users/1654885/profile_pic/1428655180/original.jpg	5	1.1%
/im/users/1311309/profile_pic/1319105126/original.jpg	4	0.9%
/im/users/1310755/profile_pic/1319620911/original.jpg	4	0.9%
/im/users/163384/profile_pic/1284286874/original.jpg	4	0.9%
/im/users/898681/profile_pic/1391541551/original.jpg	4	0.9%
/im/users/1282150/profile_pic/1390041405/original.jpg	4	0.9%
/im/users/833995/profile_pic/1311108238/original.jpg	4	0.9%
/im/users/1371414/profile_pic/1320450499/original.jpg	3	0.7%
/im/users/1968246/profile_pic/1332173070/original.jpg	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
aki_policy=profile_small	452	99.8%
v=3	1	0.2%

Value	Count	Frequency (%)
	453	100.0%

host_total_listings_count
Highly correlated

This variable is highly correlated with host_listings_count and should be ignored for analysis

Correlation	1

host_url
URL

Distinct count	381
Unique (%)	84.1%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://www.airbnb.com/users/show/1391772	9	2.0%
https://www.airbnb.com/users/show/1654885	5	1.1%
https://www.airbnb.com/users/show/898681	4	0.9%
https://www.airbnb.com/users/show/1282150	4	0.9%
https://www.airbnb.com/users/show/833995	4	0.9%
https://www.airbnb.com/users/show/1310755	4	0.9%
https://www.airbnb.com/users/show/163384	4	0.9%
https://www.airbnb.com/users/show/1311309	4	0.9%
https://www.airbnb.com/users/show/253136	3	0.7%
https://www.airbnb.com/users/show/1371414	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
www.airbnb.com	453	100.0%

Value	Count	Frequency (%)
/users/show/1391772	9	2.0%
/users/show/1654885	5	1.1%
/users/show/1311309	4	0.9%
/users/show/833995	4	0.9%
/users/show/898681	4	0.9%
/users/show/163384	4	0.9%
/users/show/1282150	4	0.9%
/users/show/1310755	4	0.9%
/users/show/1473320	3	0.7%
/users/show/253136	3	0.7%
Other values (371)	409	90.3%

Value	Count	Frequency (%)
	453	100.0%

Value	Count	Frequency (%)
	453	100.0%

host_verifications
Categorical

Distinct count	55
Unique (%)	12.1%
Missing (%)	0.0%
Missing (n)	0

['email', 'phone', 'reviews']	92
['email', 'phone', 'reviews', 'jumio', 'government_id']	56
['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id']	37
Other values (52)	268

Toggle details

Common values
Composition

Value	Count	Frequency (%)
['email', 'phone', 'reviews']	92	20.3%
['email', 'phone', 'reviews', 'jumio', 'government_id']	56	12.4%
['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id']	37	8.2%
['email', 'phone', 'facebook', 'reviews']	35	7.7%
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']	34	7.5%
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']	29	6.4%
['email', 'phone', 'reviews', 'kba']	19	4.2%
['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'government_id']	15	3.3%
['email', 'phone', 'reviews', 'jumio', 'government_id', 'work_email']	12	2.6%
['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']	11	2.4%
Other values (45)	113	24.9%

Max length	156
Mean length	63.81677704
Min length	18
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

house_rules
Categorical

Distinct count	325
Unique (%)	71.7%
Missing (%)	25.2%
Missing (n)	114

Handtücher und Bettwäsche können für 5 € pro Person gemietet werden, sonst bitte mitbringen.	3
BITTE BEACHTEN SIE DIES: Seien Sie sich bewusst, dass sich die Wohnung in einem Wohnhaus befindet und keine lauten Feiern erlaubt sind. Bitte seien Sie während Ihres Aufenthaltes so ruhig wie möglich, besonders von 22:00 bis 8:00. PLEASE NOTE THESE RULES: Be aware that the apartment is located in a residential building and no partying is tolerated. Please be as quiet as possible during your stay, especially from 10:00pm to 08:00am.	2
Smoking is only allowed in the kitchen and living room.	2
Other values (321)	332
(Missing)	114

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Handtücher und Bettwäsche können für 5 € pro Person gemietet werden, sonst bitte mitbringen.	3	0.7%
BITTE BEACHTEN SIE DIES: Seien Sie sich bewusst, dass sich die Wohnung in einem Wohnhaus befindet und keine lauten Feiern erlaubt sind. Bitte seien Sie während Ihres Aufenthaltes so ruhig wie möglich, besonders von 22:00 bis 8:00. PLEASE NOTE THESE RULES: Be aware that the apartment is located in a residential building and no partying is tolerated. Please be as quiet as possible during your stay, especially from 10:00pm to 08:00am.	2	0.4%
Smoking is only allowed in the kitchen and living room.	2	0.4%
Please note that smoking is strictly forbidden.	2	0.4%
1. No noise after 10 pm PLEASE. 2. Please do not wear outdoor shoes in the apartment. 3. Leave the apartment clean and tidy (as you found it) and dispose of your garbage. 4. Animals only by appointment - extra cleaning costs € 30.00 one time. 5. TERMS INTERNET USE: You agree to not use our Internet connection for any illegal downloads or other illegal activities. All legal cost for such activities will be paid by you.	2	0.4%
IMPORTANT ! This is a very quiet house, suitable for families or professionals and not for groups drinking a lot and being loud or coming back in the night and disturbing the neighbours. House rules: -a) always lock the doors (of your flat, the house entrance, the storage room etc.). -b) take all necessary steps to safeguard your personal property. No liability to you is accepted in respect of damage to or loss of such property, except where the damage or loss is caused by our gross negligence (see §2 Liability). -c) keep and leave the property and the furnishings, kitchen equipment, crockery, glasses clean and in the same perfect condition as you received them on arrival. -d) not to cause any damage to the walls, floors, doors, windows or any part of the property nor to do anything that may be reasonably considered to cause a nuisance or annoyance to us or to any other occupier of adjoining or neighbouring properties. -e) to ensure that each member of your party is covered by compr	2	0.4%
No smoking, loud music or hosting parties at the apartment.	2	0.4%
Before booking please accept the 'all must fell good' house rules: * Arrival to the Apartment should be between 13 and 21. * Please note that the apartment is always shared with the landlord and other guests. * No smoking indoor, or out of any windows. * You can come and go as you feel like. * Please take of your shoes when entering the corridor. * Inside the apartment it must be quiet at night from 22-07. * Please lock your door when your not in the apartment. * Leave the kitchen and bathroom in a clean condition after use. * And most important, it's a friendly place to stay :) * Sometimes the booked room is not available. Then we will assign your stay to one of the other five rooms with the same room specifications. Have a nice stay in Berlin.	2	0.4%
Optional: bedlinen and towels: 10,-- € / person pet: 20.00 €	2	0.4%
Bitte aus Rücksicht auf die nachfolgende Gäste in der Wohnung nicht rauchen. Wenn es die Belegung zulässt, können Sie gern auch schon früh am Morgen anreisen und abends abreisen. Und noch eine Bitte: Da es sich um ein älteres Haus handelt und sehr hellhörig ist, bitte abends nach 22 Uhr Gespräche nur noch in Zimmerlautstärke führen. Vielen Dank im Namen unserer Mieter und Gäste.	2	0.4%
Other values (314)	318	70.2%
(Missing)	114	25.2%

Max length	1000
Mean length	286.4260486
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

id
Numeric

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	230823.2009
Minimum	2015
Maximum	466983
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2015
5-th percentile	29888.6
Q1	169603
Median	244425
Q3	306312
95-th percentile	428583.2
Maximum	466983
Range	464968
Interquartile range	136709

Descriptive statistics

Standard deviation	114502.2697
Coef of variation	0.4960604882
Kurtosis	-0.5576514297
Mean	230823.2009
MAD	90695.30055
Skewness	-0.1318743799
Sum	104562910
Variance	1.311076977e+10
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 2015. 64417.5 169109. 250015. 250741. 265371.5 265438.5 323246.5 323259.5 466983. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
306829	1	0.2%
307587	1	0.2%
306502	1	0.2%
265402	1	0.2%
261452	1	0.2%
177486	1	0.2%
439631	1	0.2%
323920	1	0.2%
358746	1	0.2%
149849	1	0.2%
Other values (443)	443	97.8%

Minimum 5 values

Value	Count	Frequency (%)
2015	1	0.2%
2695	1	0.2%
3176	1	0.2%
3309	1	0.2%
7071	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
466983	1	0.2%
464324	1	0.2%
462459	1	0.2%
458800	1	0.2%
458608	1	0.2%

instant_bookable
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	337
t	116

Toggle details

Value	Count	Frequency (%)
f	337	74.4%
t	116	25.6%

interaction
Categorical

Distinct count	195
Unique (%)	43.0%
Missing (%)	52.3%
Missing (n)	237

You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel.	9
Bei Problemen und Fragen bin ich immer erreichbar.	3
Wir wohnen im gleichen Haus, das macht die Kommunikation sehr einfach.	3
Other values (191)	201
(Missing)	237

Toggle details

Common values
Composition

Value	Count	Frequency (%)
You will be welcomed by our friendly and open Staff, who will help you with good advices and guarantee a great stay in our hostel.	9	2.0%
Bei Problemen und Fragen bin ich immer erreichbar.	3	0.7%
Wir wohnen im gleichen Haus, das macht die Kommunikation sehr einfach.	3	0.7%
I leave my guests free space, but I am available for questions.	2	0.4%
The guest determines how much interaction they want. We do greet them on arrival and answer all of their questions and then can be reached by phone at any reasonable hour.	2	0.4%
Once you have booked you will receive a welcome email from us with information about the check in procedure and extensive recommendations for activities, sightseeing, restaurants and bars in Berlin. On the day of the check in, we ask all our guests to CALL US one hour prior to their arrival at the apartment. This is very important to use since we have several apartments and need to coordinate with different guests. If you don't call us, we won't be able to check you in! During your stay with us we will also be there for you by email or phone.	2	0.4%
As I live there myself there's quite a lot of interaction with the guests - depending on what they want and how busy I am.	2	0.4%
Gerne stehe ich für allerlei Informationen bereit und gebe auch gerne "Insidertipps" und versuche euch jede Frage zu beantworten... - Wo gibt es die beste Pho Bo? Welches Restaurant sollte man meiden? Wo kann ich am Dienstag Abend Jazz lauschen? Wo gibt es Kunst umsonst? Wo muss ich Fotos machen? Welche Club geht, welcher geht gar nicht? Was ist typisch Friedrichshain?	2	0.4%
We can be contacted on our cell phones if a guest needs help	2	0.4%
Frågor? Jag försöker att svara och lösa de flesta frågor som mina gäster har. Det finns inga problem, bara lösningar ....	2	0.4%
Other values (184)	187	41.3%
(Missing)	237	52.3%

Max length	1000
Mean length	72.18763797
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

is_business_travel_ready
Constant

This variable is constant and should be ignored for analysis

Constant value	f

is_location_exact
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

t	415
f	38

Toggle details

Value	Count	Frequency (%)
t	415	91.6%
f	38	8.4%

jurisdiction_names
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

last_review
Categorical

Distinct count	218
Unique (%)	48.1%
Missing (%)	3.5%
Missing (n)	16

2018-11-04	18
2018-10-14	14
2018-10-31	12
Other values (214)	393
(Missing)	16

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2018-11-04	18	4.0%
2018-10-14	14	3.1%
2018-10-31	12	2.6%
2018-11-03	10	2.2%
2018-10-21	9	2.0%
2018-10-24	9	2.0%
2018-10-30	9	2.0%
2018-10-29	8	1.8%
2018-11-05	8	1.8%
2018-11-01	7	1.5%
Other values (207)	333	73.5%
(Missing)	16	3.5%

Max length	10
Mean length	9.752759382
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

last_scraped
Constant

This variable is constant and should be ignored for analysis

Constant value	2018-11-07

latitude
Numeric

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	52.51074992
Minimum	52.37827969
Maximum	52.62708837
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	52.37827969
5-th percentile	52.44305074
Q1	52.49449572
Median	52.51109473
Q3	52.53284934
95-th percentile	52.5517375
Maximum	52.62708837
Range	0.2488086812
Interquartile range	0.03835362111

Descriptive statistics

Standard deviation	0.03468644112
Coef of variation	0.0006605588602
Kurtosis	2.58203623
Mean	52.51074992
MAD	0.02531851971
Skewness	-0.8053213985
Sum	23787.36971
Variance	0.001203149197
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[52.37827969 52.4754785 52.48799616 52.51329724 52.52748711 52.54413527 52.55258389 52.62708837], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
52.54968096	1	0.2%
52.49847237	1	0.2%
52.51654715	1	0.2%
52.54250549	1	0.2%
52.54062968	1	0.2%
52.5181772	1	0.2%
52.47587686	1	0.2%
52.43510474	1	0.2%
52.50329385	1	0.2%
52.54385541	1	0.2%
Other values (443)	443	97.8%

Minimum 5 values

Value	Count	Frequency (%)
52.37827969	1	0.2%
52.3787808	1	0.2%
52.37886768	1	0.2%
52.38057986	1	0.2%
52.39178909	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
52.62708837	1	0.2%
52.60825279	1	0.2%
52.60326604	1	0.2%
52.59656149	1	0.2%
52.59403928	1	0.2%

license
Categorical

Distinct count	100
Unique (%)	22.1%
Missing (%)	77.3%
Missing (n)	350

0 gewerblich	3
Gewerbe!	2
AF/000106-14	2
Other values (96)	96
(Missing)	350

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0 gewerblich	3	0.7%
Gewerbe!	2	0.4%
AF/000106-14	2	0.4%
01/Z/RA/008536-18	1	0.2%
03/Z/RA/003442-18	1	0.2%
01/Z/ZA/004844-16	1	0.2%
Nicht benötigt	1	0.2%
03/Z/RA/003546-18	1	0.2%
12/z/ZA/001518-17	1	0.2%
01/Z/NA/003813-15	1	0.2%
Other values (89)	89	19.6%
(Missing)	350	77.3%

Max length	89
Mean length	6.441501104
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

listing_url
URL

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://www.airbnb.com/rooms/401242	1	0.2%
https://www.airbnb.com/rooms/297521	1	0.2%
https://www.airbnb.com/rooms/305987	1	0.2%
https://www.airbnb.com/rooms/327442	1	0.2%
https://www.airbnb.com/rooms/37836	1	0.2%
https://www.airbnb.com/rooms/252993	1	0.2%
https://www.airbnb.com/rooms/238275	1	0.2%
https://www.airbnb.com/rooms/366094	1	0.2%
https://www.airbnb.com/rooms/408756	1	0.2%
https://www.airbnb.com/rooms/28711	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
www.airbnb.com	453	100.0%

Value	Count	Frequency (%)
/rooms/81049	1	0.2%
/rooms/183206	1	0.2%
/rooms/229776	1	0.2%
/rooms/266181	1	0.2%
/rooms/17409	1	0.2%
/rooms/462459	1	0.2%
/rooms/278860	1	0.2%
/rooms/297521	1	0.2%
/rooms/452164	1	0.2%
/rooms/342637	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
	453	100.0%

Value	Count	Frequency (%)
	453	100.0%

longitude
Numeric

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.40058422
Minimum	13.16417768
Maximum	13.65278723
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	13.16417768
5-th percentile	13.29638914
Q1	13.37267708
Median	13.41118504
Q3	13.43205992
95-th percentile	13.47066402
Maximum	13.65278723
Range	0.4886095444
Interquartile range	0.05938284159

Descriptive statistics

Standard deviation	0.06289275209
Coef of variation	0.004693284342
Kurtosis	3.231561664
Mean	13.40058422
MAD	0.04461159739
Skewness	-0.05946621513
Sum	6070.464651
Variance	0.003955498265
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[13.16417768 13.29100369 13.36046118 13.38150305 13.40351508 13.42973709 13.47190485 13.65119412 13.65278723], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
13.41705422	1	0.2%
13.36466023	1	0.2%
13.41603795	1	0.2%
13.29651397	1	0.2%
13.42852671	1	0.2%
13.38847176	1	0.2%
13.40286718	1	0.2%
13.44377284	1	0.2%
13.42814429	1	0.2%
13.43719326	1	0.2%
Other values (443)	443	97.8%

Minimum 5 values

Value	Count	Frequency (%)
13.16417768	1	0.2%
13.1644643	1	0.2%
13.17573477	1	0.2%
13.21214126	1	0.2%
13.22265649	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
13.65278723	1	0.2%
13.65275115	1	0.2%
13.65123141	1	0.2%
13.65115684	1	0.2%
13.63528316	1	0.2%

market
Constant

This variable is constant and should be ignored for analysis

Constant value	Berlin

maximum_nights
Numeric

Distinct count	71
Unique (%)	15.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	367.5827815
Minimum	3
Maximum	2000
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	3
5-th percentile	13.6
Q1	31
Median	360
Q3	365
95-th percentile	1125
Maximum	2000
Range	1997
Interquartile range	334

Descriptive statistics

Standard deviation	401.0065106
Coef of variation	1.090928441
Kurtosis	0.3317310345
Mean	367.5827815
MAD	303.7272634
Skewness	1.15757878
Sum	166515
Variance	160806.2216
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 3. 13.5 15.5 19.5 21.5 ... 726.5 745. 1122. 1162.5 2000. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
365	118	26.0%
1125	62	13.7%
30	33	7.3%
60	30	6.6%
90	17	3.8%
730	15	3.3%
21	14	3.1%
14	13	2.9%
360	10	2.2%
180	9	2.0%
Other values (61)	132	29.1%

Minimum 5 values

Value	Count	Frequency (%)
3	1	0.2%
4	2	0.4%
5	1	0.2%
6	2	0.4%
7	6	1.3%

Maximum 5 values

Value	Count	Frequency (%)
2000	1	0.2%
1825	1	0.2%
1200	1	0.2%
1125	62	13.7%
1124	4	0.9%

medium_url
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

minimum_nights
Numeric

Distinct count	29
Unique (%)	6.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	16.29139073
Minimum	1
Maximum	270
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
Median	3
Q3	6
95-th percentile	90
Maximum	270
Range	269
Interquartile range	4

Descriptive statistics

Standard deviation	33.20743121
Coef of variation	2.038342322
Kurtosis	13.83717662
Mean	16.29139073
MAD	21.41768636
Skewness	3.292859221
Sum	7380
Variance	1102.733488
Memory size	3.6 KiB

Histogram with fixed size bins (bins=29)

Histogram with variable size bins (bins=[ 1. 3.5 5.5 7.5 14.5 ... 59. 61. 87.5 90.5 270. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	116	25.6%
3	103	22.7%
1	55	12.1%
5	33	7.3%
4	32	7.1%
60	29	6.4%
90	16	3.5%
7	10	2.2%
30	10	2.2%
62	7	1.5%
Other values (19)	42	9.3%

Minimum 5 values

Value	Count	Frequency (%)
1	55	12.1%
2	116	25.6%
3	103	22.7%
4	32	7.1%
5	33	7.3%

Maximum 5 values

Value	Count	Frequency (%)
270	1	0.2%
183	1	0.2%
180	4	0.9%
150	1	0.2%
120	2	0.4%

monthly_price
Categorical

Distinct count	113
Unique (%)	24.9%
Missing (%)	43.0%
Missing (n)	195

$1,200.00	17
$1,500.00	11
$1,400.00	10
Other values (109)	220
(Missing)	195

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$1,200.00	17	3.8%
$1,500.00	11	2.4%
$1,400.00	10	2.2%
$1,000.00	10	2.2%
$900.00	10	2.2%
$1,100.00	8	1.8%
$1,300.00	7	1.5%
$800.00	6	1.3%
$600.00	6	1.3%
$750.00	6	1.3%
Other values (102)	167	36.9%
(Missing)	195	43.0%

Max length	9
Mean length	5.962472406
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

name
Categorical

Distinct count	452
Unique (%)	99.8%
Missing (%)	0.0%
Missing (n)	0

Apartment in the heart of Berlin	2
Geourgeous flat - outstanding views	1
Nice room for 3 persons	1
Other values (449)	449

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Apartment in the heart of Berlin	2	0.4%
Geourgeous flat - outstanding views	1	0.2%
Nice room for 3 persons	1	0.2%
QUIET GARDEN APT(child friendly)	1	0.2%
BerlinSpot Schöneberg near KaDeWe	1	0.2%
In the middle of Mitte and green!	1	0.2%
Adorable apartment in the City Center of Berlin	1	0.2%
Awesome Location Mitte / P'berg	1	0.2%
2 apartment in Berlin Center, WiFi	1	0.2%
CasaKaiser, 2 room apartment	1	0.2%
Other values (442)	442	97.6%

Max length	71
Mean length	32.9183223
Min length	9
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

neighborhood_overview
Categorical

Distinct count	220
Unique (%)	48.6%
Missing (%)	46.6%
Missing (n)	211

Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries, theaters and cultural institutions with many really cheap small meal occasions with specialties from around the world. In addition, there's the spectacular collection of Berlin's best clubs, which are in large part all within walking distance. Because in 200 meters distance, among other things, there is the Berghain / Panorama Bar, which was chosen not only by the New York Times as the "best club in the world".	9
Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. In Berlin bieten sich zahlreiche Möglichkeiten, historische und moderne Kultur besuchen, sich zu erholen, das Zusammenwachsen von Ost und West intensiv und lebendig erleben. Besondere Anziehungspunkten sind der historische Stadtkern mit dem Brandenburger Tor und der Straße unter den Linden sowie dem angrenzenden Regierungsviertel, einzigartige Museen, eine traditionsreiche Industriekultur, moderne Architektur oder die städtischen Naherholungsgebiete. Auf Wunsch gestalten wir Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5
In direkter Umgebung ist ein Supermarkt mit Bäcker, einige Clubs, Bars, Restaurants und Kino. Die Spree und ein großer Park sind auch in Laufweite.	3
Other values (216)	225
(Missing)	211

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Home of this pretty accommodation is Friedrichshain, one of the central districs in Berlin, surrounded by Prenzlauer Berg, Mitte and Kreuzberg. Friedrichshain distinguishes himself as a student and artist district by its young and creative activities. Primarily due to the numerous bars, cafes, restaurants, galleries, theaters and cultural institutions with many really cheap small meal occasions with specialties from around the world. In addition, there's the spectacular collection of Berlin's best clubs, which are in large part all within walking distance. Because in 200 meters distance, among other things, there is the Berghain / Panorama Bar, which was chosen not only by the New York Times as the "best club in the world".	9	2.0%
Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. In Berlin bieten sich zahlreiche Möglichkeiten, historische und moderne Kultur besuchen, sich zu erholen, das Zusammenwachsen von Ost und West intensiv und lebendig erleben. Besondere Anziehungspunkten sind der historische Stadtkern mit dem Brandenburger Tor und der Straße unter den Linden sowie dem angrenzenden Regierungsviertel, einzigartige Museen, eine traditionsreiche Industriekultur, moderne Architektur oder die städtischen Naherholungsgebiete. Auf Wunsch gestalten wir Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5	1.1%
In direkter Umgebung ist ein Supermarkt mit Bäcker, einige Clubs, Bars, Restaurants und Kino. Die Spree und ein großer Park sind auch in Laufweite.	3	0.7%
The apartment is located in the trendy, vibrant district of Prenzlauer Berg, bordering on artistic, cosmopolitan Mitte. The Oderberger Strasse is a very lively yet very relaxed street that offers the distinctively bohemian vibe Prenzlauer Berg has been made famous for. Artsy cafés, quaint boutiques and laid back restaurants make it a favourite destination of locals and visitors alike. Neighbourhood highlights include the Kastanienallee with its dozens of bars, restaurants and coffee shops -among which the renowned Prater, Berlin’s oldest beer garden- and the Mauerpark with its very popular Sunday flea market. The entertainment complex of the Kulturbrauerei is just around the corner, as well as the Kollwitzplatz with its fine wining and dining (and, of course, shopping). The not-to-be-missed Berlin Wall Memorial is in the vicinity of the apartments whereas Berlin landmarks such as the TV Tower or the Museum Island are a leisurely stroll. This is an ideal base for exploring Berlin: rig	2	0.4%
Our apartment is located in the beautiful and trendy Prenzlauer Berg district, known for its thriving cafe, club and art gallery culture. Excellent public transport connections take you into Mitte in about 10 minutes, where you can visit main Berlin attractions such as Alexanderplatz, Museum Island, or Hackescher Markt. From there you can walk to the Brandenburg Gate and Checkpoint Charlie. The tram M10 connects the Prenzlauer Berg with Friedrichshain where you can visit the famous East Side Gallery or enjoy Berlin’s buzzing night life. In the Prenzlauer Berg you will find plenty of cafés, kitsch boutiques and alternative-style bars. The popular Kollwitzplatz is only a leisurely 15-20 min stroll away, same as the Kulturbrauerei, an old brewery with shops and nightlife. Also nearby is the huge & popular park "Volkspark Friedrichshain", with lakes, a fairytale fountain, film showings and beer gardens. Don't miss the nearby Mauerpark with its large flea market and renowned outdoor karaok	2	0.4%
Despite the central location a very quiet street, in the vicinity are many cafes, restaurants and various supermarkets	2	0.4%
There is a supermarket at the 1 floor of the building. The Apartment is located on Wilhelmstrasse. 2 blocks from Potsdamer Platz, the Berlin Wall and the Holocaust Memorial, also 3 blocks from the Brandenburg Gate and Check-Point Charlie. There are several restaurants just across the street. There's also the biggest shopping mall in Germany just across the street If you like bikes, there is a souvenir shop downstairs where you can also rent bikes for EUR 10.00 per day (the price may vary according to the shop owners decision)	2	0.4%
The neighbourhood is one of the coolest and hippest in all over Berlin - there are plenty of cafés, bars, restaurants, clubs and funky shops around. At one end of the street is the river Spree and the East Side Gallery, at the other there is Görlitzer Park.	2	0.4%
Här bor Du mitt i centrala Berlin direkt vid floden Spree, med 5 minuter till Skeppskajen för en båt- tur. Dessutom precis i kanten av Europas största park: Tiergarten; här han Du cykla, promenera och uppleva det mesta.	2	0.4%
Luxery villa neighborhood in the best area of Berlin.	2	0.4%
Other values (209)	211	46.6%
(Missing)	211	46.6%

Max length	1000
Mean length	227.4834437
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

neighbourhood
Categorical

Distinct count	48
Unique (%)	10.6%
Missing (%)	7.1%
Missing (n)	32

Prenzlauer Berg	83
Mitte	60
Kreuzberg	51
Other values (44)	227

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Prenzlauer Berg	83	18.3%
Mitte	60	13.2%
Kreuzberg	51	11.3%
Friedrichshain	45	9.9%
Neukölln	33	7.3%
Schöneberg	28	6.2%
Charlottenburg	23	5.1%
Moabit	11	2.4%
Wedding	8	1.8%
Wilmersdorf	8	1.8%
Other values (37)	71	15.7%
(Missing)	32	7.1%

Max length	17
Mean length	9.958057395
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

neighbourhood_cleansed
Categorical

Distinct count	79
Unique (%)	17.4%
Missing (%)	0.0%
Missing (n)	0

Prenzlauer Berg Südwest	34
Brunnenstr. Süd	31
Frankfurter Allee Süd FK	29
Other values (76)	359

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Prenzlauer Berg Südwest	34	7.5%
Brunnenstr. Süd	31	6.8%
Frankfurter Allee Süd FK	29	6.4%
Alexanderplatz	27	6.0%
Tempelhofer Vorstadt	23	5.1%
Helmholtzplatz	22	4.9%
Schöneberg-Nord	20	4.4%
südliche Luisenstadt	18	4.0%
Reuterstraße	17	3.8%
Prenzlauer Berg Süd	13	2.9%
Other values (69)	219	48.3%

Max length	41
Mean length	17.10596026
Min length	5
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

neighbourhood_group_cleansed
Categorical

Distinct count	12
Unique (%)	2.6%
Missing (%)	0.0%
Missing (n)	0

Friedrichshain-Kreuzberg	106
Pankow	101
Mitte	91
Other values (9)	155

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Friedrichshain-Kreuzberg	106	23.4%
Pankow	101	22.3%
Mitte	91	20.1%
Neukölln	40	8.8%
Charlottenburg-Wilm.	39	8.6%
Tempelhof - Schöneberg	36	7.9%
Treptow - Köpenick	12	2.6%
Steglitz - Zehlendorf	12	2.6%
Reinickendorf	9	2.0%
Lichtenberg	4	0.9%
Other values (2)	3	0.7%

Max length	24
Mean length	13.63134658
Min length	5
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

notes
Categorical

Distinct count	191
Unique (%)	42.2%
Missing (%)	53.6%
Missing (n)	243

For privately motivated stays the Senate of Berlin requires 5% City Tax, which must additionally be paid on arrival. Business travelers are exempted from this rule, and are requested to to submit relevant supporting documents upon check-in.	9
Check-in: am Anreisetag ab 14.00 Uhr Check-out: am Abreisetag bis 10.30 Uhr	3
Bereitstellung der Bettwäsche, Handtücher und Küchentücher ist inklusive. Die Preise können je nach Aufenthalts -Länge/ -Zeitpunkt und Anzahl der Personen variieren Garagenplatz 5 €/Nacht. Checkin von (Phone number hidden by Airbnb) h, Checkout bis 11 h Checkin/checkout außerhalb der angegebenen Zeiten nur nach Vereinbarung gegen Gebühr (Phone number hidden by Airbnb) € Gebühr	3
Other values (187)	195
(Missing)	243

Toggle details

Common values
Composition

Value	Count	Frequency (%)
For privately motivated stays the Senate of Berlin requires 5% City Tax, which must additionally be paid on arrival. Business travelers are exempted from this rule, and are requested to to submit relevant supporting documents upon check-in.	9	2.0%
Check-in: am Anreisetag ab 14.00 Uhr Check-out: am Abreisetag bis 10.30 Uhr	3	0.7%
Bereitstellung der Bettwäsche, Handtücher und Küchentücher ist inklusive. Die Preise können je nach Aufenthalts -Länge/ -Zeitpunkt und Anzahl der Personen variieren Garagenplatz 5 €/Nacht. Checkin von (Phone number hidden by Airbnb) h, Checkout bis 11 h Checkin/checkout außerhalb der angegebenen Zeiten nur nach Vereinbarung gegen Gebühr (Phone number hidden by Airbnb) € Gebühr	3	0.7%
The S-Bahn passes behind the apartment. Although the impairments are minor and complaints have not been received yet at all, we would still like mention this.	2	0.4%
Guests have to bring their own towels.Bedlinen are being supplied.	2	0.4%
No place for party people!	2	0.4%
Everything is included in the price - no extra payment for anything. Should you be in need of clean clothes. I will assist you with your need for 5€ with drying.	2	0.4%
Bettwäsche und Handtücher sind im Preis inbegriffen. Es gibt ein Bügeleisen und einen Föhn. Kostenlose Internetverbindung vía Wifi/WLAN. Bitte beachten Sie, dass das Land Berlin seit 2014 für die ersten nicht berufsbedingten (also privaten) 21 Übernachtungen eine Übernachtungsteuer von 5% vom Mietbetrag erhebt, zusätzlich zahlbar bei Anreise. Bei Mietaufenthalten von mehr als 2 Monaten besteht die Verpflichtung sich bei der Meldebehörde anzumelden.	2	0.4%
Arrival with car: Our area is on-street parking controlled. From Mondays to Saturdays (9am-midnight) parking costs 1€/hour. On Sundays and red-letter days parking is free of charge. A parking garage nearby is at "Kulturbrauerei" (Mo-Sa; 7,50,-€/day). Guests arriving with a car will need an environmental sticker. Stickers can be issued by the vehicle registration office, technical certification organisations and authorised repair workshops. This applies to foreign vehicles as well. The vehicle registration documents must be presented in order to purchase a sticker.	2	0.4%
Veranstaltungen auf dem Grundstück sind ebenfalls möglich unter der Voraussetzung der Bezahlung einer Tagesgebühr in der Höhe von 15 € / Person für die Zeit von 15 bis 22 Uhr. Fahrräder und Boote können Sie in der Nähe mieten und einen Angelschein bekommen Sie im Angelshop	2	0.4%
Other values (180)	181	40.0%
(Missing)	243	53.6%

Max length	1000
Mean length	122.5011038
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

number_of_reviews
Numeric

Distinct count	178
Unique (%)	39.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	71.04635762
Minimum	0
Maximum	498
Zeros (%)	3.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	11
Median	40
Q3	101
95-th percentile	247.8
Maximum	498
Range	498
Interquartile range	90

Descriptive statistics

Standard deviation	85.41369948
Coef of variation	1.20222489
Kurtosis	4.51946904
Mean	71.04635762
MAD	62.47661652
Skewness	1.998846199
Sum	32184
Variance	7295.500059
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 1.5 18.5 73.5 164.5 278. 498. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	16	3.5%
1	16	3.5%
6	13	2.9%
3	12	2.6%
5	12	2.6%
18	10	2.2%
7	9	2.0%
4	8	1.8%
10	8	1.8%
15	8	1.8%
Other values (168)	341	75.3%

Minimum 5 values

Value	Count	Frequency (%)
0	16	3.5%
1	16	3.5%
2	6	1.3%
3	12	2.6%
4	8	1.8%

Maximum 5 values

Value	Count	Frequency (%)
498	1	0.2%
443	1	0.2%
426	1	0.2%
413	1	0.2%
398	1	0.2%

picture_url
URL

Distinct count	453
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0

Toggle details

Value	Count	Frequency (%)
https://a0.muscache.com/im/pictures/4136167/0e062f27_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/90111571/6cd136af_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/598734/9f90bc3b_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/2865342/0e403791_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/f0a7a8e7-b2e4-47af-9c60-118143655a21.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/3395313/68d44d1e_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/55198a7e-6fe6-4c7c-a45f-2417ff2e0c86.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/342014/22302c71_original.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/7e5940a0-9f26-4536-9937-0429c5bbedb5.jpg?aki_policy=large	1	0.2%
https://a0.muscache.com/im/pictures/11298416/d089e3e6_original.jpg?aki_policy=large	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
https	453	100.0%

Value	Count	Frequency (%)
a0.muscache.com	453	100.0%

Value	Count	Frequency (%)
/im/pictures/87339838/bf64f8ac_original.jpg	1	0.2%
/im/pictures/3510624/b39bccf1_original.jpg	1	0.2%
/im/pictures/3554501/08067439_original.jpg	1	0.2%
/im/pictures/ecbd4e81-3a23-4a1f-a779-a138e2dc693a.jpg	1	0.2%
/im/pictures/3395313/68d44d1e_original.jpg	1	0.2%
/im/pictures/343d754b-ef9d-4ffd-aa13-fad89393f292.jpg	1	0.2%
/im/pictures/2835503/64ffcce8_original.jpg	1	0.2%
/im/pictures/954060d0-cb65-4c06-8055-893e82da13e7.jpg	1	0.2%
/im/pictures/3637432/a17ae7d8_original.jpg	1	0.2%
/im/pictures/06138530-4d34-4140-8d89-20b70aff2262.jpg	1	0.2%
Other values (443)	443	97.8%

Value	Count	Frequency (%)
aki_policy=large	453	100.0%

Value	Count	Frequency (%)
	453	100.0%

price
Categorical

Distinct count	104
Unique (%)	23.0%
Missing (%)	0.0%
Missing (n)	0

$55.00	24
$70.00	22
$60.00	20
Other values (101)	387

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$55.00	24	5.3%
$70.00	22	4.9%
$60.00	20	4.4%
$65.00	18	4.0%
$49.00	15	3.3%
$50.00	15	3.3%
$75.00	15	3.3%
$80.00	14	3.1%
$45.00	14	3.1%
$29.00	13	2.9%
Other values (94)	283	62.5%

Max length	7
Mean length	6.112582781
Min length	5
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

property_type
Categorical

Distinct count	16
Unique (%)	3.5%
Missing (%)	0.0%
Missing (n)	0

Apartment	378
House	19
Condominium	17
Other values (13)	39

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Apartment	378	83.4%
House	19	4.2%
Condominium	17	3.8%
Loft	11	2.4%
Hostel	9	2.0%
Bed and breakfast	4	0.9%
Other	3	0.7%
Guesthouse	2	0.4%
Townhouse	2	0.4%
Boutique hotel	2	0.4%
Other values (6)	6	1.3%

Max length	18
Mean length	8.792494481
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

require_guest_phone_verification
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	390
t	63

Toggle details

Value	Count	Frequency (%)
f	390	86.1%
t	63	13.9%

require_guest_profile_picture
Boolean

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

f	418
t	35

Toggle details

Value	Count	Frequency (%)
f	418	92.3%
t	35	7.7%

requires_license
Constant

This variable is constant and should be ignored for analysis

Constant value	t

review_scores_accuracy
Numeric

Distinct count	7
Unique (%)	1.5%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.569124424
Minimum	5
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	5
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	5
Interquartile range	1

Descriptive statistics

Standard deviation	0.6803515381
Coef of variation	0.07109861968
Kurtosis	8.859038324
Mean	9.569124424
MAD	0.5519972817
Skewness	-2.30753659
Sum	4153
Variance	0.4628782154
Memory size	3.6 KiB

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	278	61.4%
9	135	29.8%
8	16	3.5%
6	3	0.7%
7	1	0.2%
5	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
5	1	0.2%
6	3	0.7%
7	1	0.2%
8	16	3.5%
9	135	29.8%

Maximum 5 values

Value	Count	Frequency (%)
10	278	61.4%
9	135	29.8%
8	16	3.5%
7	1	0.2%
6	3	0.7%

review_scores_checkin
Numeric

Distinct count	6
Unique (%)	1.3%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.665898618
Minimum	4
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	6
Interquartile range	1

Descriptive statistics

Standard deviation	0.6493117684
Coef of variation	0.06717552026
Kurtosis	26.1484077
Mean	9.665898618
MAD	0.478827327
Skewness	-3.812545244
Sum	4195
Variance	0.4216057726
Memory size	3.6 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	311	68.7%
9	110	24.3%
8	10	2.2%
4	2	0.4%
7	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
4	2	0.4%
7	1	0.2%
8	10	2.2%
9	110	24.3%
10	311	68.7%

Maximum 5 values

Value	Count	Frequency (%)
10	311	68.7%
9	110	24.3%
8	10	2.2%
7	1	0.2%
4	2	0.4%

review_scores_cleanliness
Numeric

Distinct count	7
Unique (%)	1.5%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.48156682
Minimum	4
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	8
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	6
Interquartile range	1

Descriptive statistics

Standard deviation	0.6936740464
Coef of variation	0.07316027609
Kurtosis	9.751037287
Mean	9.48156682
MAD	0.5829386906
Skewness	-2.060822245
Sum	4115
Variance	0.4811836826
Memory size	3.6 KiB

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	244	53.9%
9	163	36.0%
8	23	5.1%
7	2	0.4%
4	1	0.2%
6	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
4	1	0.2%
6	1	0.2%
7	2	0.4%
8	23	5.1%
9	163	36.0%

Maximum 5 values

Value	Count	Frequency (%)
10	244	53.9%
9	163	36.0%
8	23	5.1%
7	2	0.4%
6	1	0.2%

review_scores_communication
Numeric

Distinct count	8
Unique (%)	1.8%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.633640553
Minimum	2
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	8
Interquartile range	1

Descriptive statistics

Standard deviation	0.7331617882
Coef of variation	0.07610433295
Kurtosis	35.46267726
Mean	9.633640553
MAD	0.516617469
Skewness	-4.497039061
Sum	4181
Variance	0.5375262077
Memory size	3.6 KiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
10	306	67.5%
9	110	24.3%
8	14	3.1%
4	1	0.2%
2	1	0.2%
7	1	0.2%
6	1	0.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
2	1	0.2%
4	1	0.2%
6	1	0.2%
7	1	0.2%
8	14	3.1%

Maximum 5 values

Value	Count	Frequency (%)
10	306	67.5%
9	110	24.3%
8	14	3.1%
7	1	0.2%
6	1	0.2%

review_scores_location
Numeric

Distinct count	6
Unique (%)	1.3%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.513824885
Minimum	6
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6
5-th percentile	9
Q1	9
Median	10
Q3	10
95-th percentile	10
Maximum	10
Range	4
Interquartile range	1

Descriptive statistics

Standard deviation	0.6419101307
Coef of variation	0.06747129977
Kurtosis	3.866522418
Mean	9.513824885
MAD	0.5601095797
Skewness	-1.499131842
Sum	4129
Variance	0.4120486159
Memory size	3.6 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	250	55.2%
9	163	36.0%
8	17	3.8%
6	2	0.4%
7	2	0.4%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
6	2	0.4%
7	2	0.4%
8	17	3.8%
9	163	36.0%
10	250	55.2%

Maximum 5 values

Value	Count	Frequency (%)
10	250	55.2%
9	163	36.0%
8	17	3.8%
7	2	0.4%
6	2	0.4%

review_scores_rating
Numeric

Distinct count	27
Unique (%)	6.0%
Missing (%)	4.2%
Missing (n)	19
Infinite (%)	0.0%
Infinite (n)	0

Mean	93.62903226
Minimum	73
Maximum	100
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	73
5-th percentile	83
Q1	91
Median	94.5
Q3	97
95-th percentile	100
Maximum	100
Range	27
Interquartile range	6

Descriptive statistics

Standard deviation	5.159191934
Coef of variation	0.05510248061
Kurtosis	1.211616605
Mean	93.62903226
MAD	3.984837223
Skewness	-1.121838086
Sum	40635
Variance	26.61726142
Memory size	3.6 KiB

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
96	49	10.8%
100	48	10.6%
94	41	9.1%
98	39	8.6%
97	37	8.2%
93	36	7.9%
95	26	5.7%
92	25	5.5%
90	19	4.2%
99	18	4.0%
Other values (16)	96	21.2%
(Missing)	19	4.2%

Minimum 5 values

Value	Count	Frequency (%)
73	1	0.2%
75	1	0.2%
76	1	0.2%
77	1	0.2%
79	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
100	48	10.6%
99	18	4.0%
98	39	8.6%
97	37	8.2%
96	49	10.8%

review_scores_value
Numeric

Distinct count	6
Unique (%)	1.3%
Missing (%)	4.4%
Missing (n)	20
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.270207852
Minimum	6
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	6
5-th percentile	8
Q1	9
Median	9
Q3	10
95-th percentile	10
Maximum	10
Range	4
Interquartile range	1

Descriptive statistics

Standard deviation	0.6586069778
Coef of variation	0.07104554593
Kurtosis	2.379397733
Mean	9.270207852
MAD	0.5359674434
Skewness	-0.8909035014
Sum	4014
Variance	0.4337631511
Memory size	3.6 KiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
9	239	52.8%
10	159	35.1%
8	30	6.6%
7	3	0.7%
6	2	0.4%
(Missing)	20	4.4%

Minimum 5 values

Value	Count	Frequency (%)
6	2	0.4%
7	3	0.7%
8	30	6.6%
9	239	52.8%
10	159	35.1%

Maximum 5 values

Value	Count	Frequency (%)
10	159	35.1%
9	239	52.8%
8	30	6.6%
7	3	0.7%
6	2	0.4%

reviews_per_month
Highly correlated

This variable is highly correlated with number_of_reviews and should be ignored for analysis

Correlation	0.9301967298

room_type
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

Entire home/apt	304
Private room	143
Shared room	6

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Entire home/apt	304	67.1%
Private room	143	31.6%
Shared room	6	1.3%

Max length	15
Mean length	14
Min length	11
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

scrape_id
Constant

This variable is constant and should be ignored for analysis

Constant value	20181107122246

security_deposit
Categorical

Distinct count	40
Unique (%)	8.8%
Missing (%)	25.2%
Missing (n)	114

$0.00	73
$100.00	48
$200.00	38
Other values (36)	180
(Missing)	114

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$0.00	73	16.1%
$100.00	48	10.6%
$200.00	38	8.4%
$500.00	34	7.5%
$300.00	26	5.7%
$150.00	26	5.7%
$250.00	17	3.8%
$1,000.00	14	3.1%
$400.00	12	2.6%
$800.00	8	1.8%
Other values (29)	43	9.5%
(Missing)	114	25.2%

Max length	9
Mean length	5.770419426
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

smart_location
Categorical

Distinct count	3
Unique (%)	0.7%
Missing (%)	0.0%
Missing (n)	0

Berlin, Germany	451
Berlin (Kreuzberg), Germany	1
Schöneberg, Germany	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin, Germany	451	99.6%
Berlin (Kreuzberg), Germany	1	0.2%
Schöneberg, Germany	1	0.2%

Max length	27
Mean length	15.03532009
Min length	15
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

space
Categorical

Distinct count	435
Unique (%)	96.0%
Missing (%)	1.3%
Missing (n)	6

Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes!	9
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	3
Lovely Apartment for two persons. Nice and sunny reasonable Apartment, 35 qm, modernized, quietly, traffic favourable.	2
Other values (431)	433
(Missing)	6

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Our Sunflower Hostel is characterized by its colorful and unconventional design, and offers plenty of space to meet and to exchange with other travelers. For this purpose especially our lobby invites with a bar, table football, plenty of seating and even a small pond with fishes!	9	2.0%
Welcome to a feel good stay and a quality experience in Berlin. We're offering mature hospitality, good quality in our interior with good beds, you´ll love sleeping in. This is the place to stay, if you want to experience a relaxed however stylish alternative to a hotel we're the place. You're now reading about a semi-professional host's offer to guests visiting Berlin. It means I have more rooms for rent out in the same big and spacey apartment - a 'guest house'. So be course I'm not a newbie in this business is a greater chance for at good stay in Berlin, then if you take a host with no experience and on the hunt for some extra pocket money. I charge a bit more then the other hosts, I don't offer discounts and in return the only thing I'm working for is to provide a good stay and a good nights sleep for my guests. Great apartment, great room, big kitchen and two baths/toilets! The room is big and spacious and decorated to give you a space to relax. The apartment is in a very quiet	3	0.7%
Lovely Apartment for two persons. Nice and sunny reasonable Apartment, 35 qm, modernized, quietly, traffic favourable.	2	0.4%
The accommodation is located in the district of Neukölln, in the middle of the old Bohemian Rixdorf, a historical working class quarter that was once founded in 1737. Berlin-Neukölln offers many cafés, bars and shopping opportunities, international cultural offerings such as the Neukölln opera, movies, numerous galleries as well as the Volkspark Hasenheide are within walking distance. We offer single, double, 3 beds rooms and a holiday home. There are 2 shared bathrooms and a small kitchen available for the rooms. They are also suitable for small groups of up to 10 persons. The holiday apartment is suitable for up to 4 persons and is situated on the 2nd floor. It has 1 room with TV, bathroom, kitchen and a washing machine. Berlin offers many opportunities to experience both historical & modern culture and space to relax. The growing together of East and West can be intensely experienced in Berlin, in particular. Among the most attracting sights you find the historical city center with	2	0.4%
Dear holiday-guests, the multi-family flat has an historic background of formerly being a barn-house for carriage drivers in 1906. It is located in the gorgeous and very safe siting of Berlin Wannsee. The area of Wannsee, in which the two apartments lie, offers a beautiful variety of landscape, spreading from forest, to lakes and to culture. This however does not limit the quick access into the city, be it by car or by public transportation. The S-Bahn station Wannsee can easily be approached by foot. From there the S-Bahn will transport you every 10 minutes to areas like the Ku’damm (20 minutes) or the Potsdamer Platz (30 minutes). Potsdam is practically around the corner. The apartments (one in ground floor and one in first floor) each feature a little separate bedroom and a combined living-room and dining-room with an additional sofa-bed. They can be booked for up to two adults and two children. These living facilities are very well equipped and furnished with a love for detail (Wi-	2	0.4%
This is a 3 bedrooms apartment very well located with easy access to the public transportation and also close to the major sigh-seeing in Berlin. This is a Small room, it has 15m2, there is 1 double bed (140x200cm), 1 sofa-bed. I also provide Bed sheets blankets and towels and of course WIFI is free.	1	0.2%
I offer a room with high ceilings and wooden floor, all nicely renovated in an old beautiful building - Berlin style. It has a double bed with a luxury mattress, and two big windows facing a lovely back yard. The apartment is clean, quiet, and near to Hermannstrasse station. It would take you only 14 minutes to get to Alexanderplatz or to Potsdamer Platz. The area is very vivid, close to bars, cafés with live music, parks and many stores. The apartment has a wireless internet connection. You will get bed sheets and towels, and can make free phone calls to landlines in Germany. You can use the laundry machine for 3 Euros. I have one small and sweet dog that sometimes stay in the apartment. There is free parking in the area. For me, I live in Berlin for many years, so I will be happy to help and tell everything you need to know in order to make the best out of your stay in the city. I speak english, german and hebrew, and have a non smoking household. לאלה מכם שמדברים עברית, שמי מיה שי	1	0.2%
Welcome to Boxhagener area of Berlin! A lively, trendy neighbourhood with lots of bars, cafes, restaurants and shops to choose from. Great connections to other parts of the city: Tram 21 & 16, U-Bahn Line 5 and S-Bahn lines 5, 7, 9 & Ringbahn (Circle line) plus buses. Close to Frankfurter Allee and Ostkreuz stations. My roof flat is on the 5th floor, and there is no lift. The exercise is free! The flat itself has an open kitchen / living room area and 1 bathroom (with bath tub) which is to be shared. Huge windows at the front have a great view across the Berlin rooftops and skylights throughout flood the flat with daylight. Generally it is pretty quiet here. I include wireless internet access as well as tea and coffee. Heating and hot water, of course, are included too. The room that I would like to offer you is approx 11sqm, roughly square shaped, with 2.5m high ceilings, there is only a small part with a sloping roof. The window overlooks the inner patio. There is a comfortable sofa	1	0.2%
Centrally located between the Opera and the castle, next to subway and bus. Telephone, wireless flat, garage 2-room apartment, 48 square meters for a maximum number. 4 people. Beautiful, bright apartment, renovated in 2008, the 6th Floor (elevator) overlooking the dome of Schloss Charlottenburg to Spandau to The apartments Friederike and Louise can be booked individually or together, since they are connected to a sound-insulating double doors can be opened as required by the owner	1	0.2%
the apartment has an organic ground- plan with an integrated kitchen. The appartment is completely renovated. (new bathroom, new hardwood floors and new kitchen). It is located in the charming neighborhood of Charlottenburg with nice, fency cafes, good shopping and excellent connections with public transport. Close to the Messe Berlin / ICC and the Kurfürstendamm. The apartment is on the 5th floor with elevator. Parking is in front of the house.Telephone and Internet connection available. Looking for nice tenants who enjoy their stay in my appartment.	1	0.2%
Other values (424)	424	93.6%
(Missing)	6	1.3%

Max length	1000
Mean length	819.0684327
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

square_feet
Numeric

Distinct count	68
Unique (%)	15.0%
Missing (%)	63.1%
Missing (n)	286
Infinite (%)	0.0%
Infinite (n)	0

Mean	416.6407186
Minimum	0
Maximum	1722
Zeros (%)	9.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	377
Q3	662
95-th percentile	1275.8
Maximum	1722
Range	1722
Interquartile range	662

Descriptive statistics

Standard deviation	402.6682724
Coef of variation	0.9664640408
Kurtosis	0.90989614
Mean	416.6407186
MAD	322.1080713
Skewness	1.00931902
Sum	69579
Variance	162141.7376
Memory size	3.6 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	45	9.9%
753	7	1.5%
646	7	1.5%
269	5	1.1%
807	4	0.9%
775	4	0.9%
377	4	0.9%
431	4	0.9%
474	3	0.7%
484	3	0.7%
Other values (57)	81	17.9%
(Missing)	286	63.1%

Minimum 5 values

Value	Count	Frequency (%)
0	45	9.9%
15	1	0.2%
17	1	0.2%
20	1	0.2%
46	1	0.2%

Maximum 5 values

Value	Count	Frequency (%)
1722	2	0.4%
1615	2	0.4%
1400	1	0.2%
1399	1	0.2%
1292	3	0.7%

state
Categorical

Distinct count	2
Unique (%)	0.4%
Missing (%)	0.7%
Missing (n)	3

Berlin	450
(Missing)	3

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin	450	99.3%
(Missing)	3	0.7%

Max length	6
Mean length	5.98013245
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

street
Categorical

Distinct count	4
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

Berlin, Berlin, Germany	448
Berlin, Germany	3
Schöneberg, Berlin, Germany	1

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Berlin, Berlin, Germany	448	98.9%
Berlin, Germany	3	0.7%
Schöneberg, Berlin, Germany	1	0.2%
Berlin (Kreuzberg), Berlin, Germany	1	0.2%

Max length	35
Mean length	22.98233996
Min length	15
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

summary
Categorical

Distinct count	285
Unique (%)	62.9%
Missing (%)	34.4%
Missing (n)	156

Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. Auf Wunsch Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5
we are a guesthouse and not a private appartment. every room/appartment with its own entrance and bathroom.	4
Schön eingerichtete 3-Zimmerwohnung mit 2 Schlafzimmern und Internetanschluss . Aus der 10. Etg eines Mehrfamilienhauses gibt es einen herrlichen Ausblick auf den Fernsehturm und den Alexanderplatz in der Nähe.	4
Other values (281)	284
(Missing)	156

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Die Unterkünfte liegen im Bezirk Neukölln mitten im 1737 gegründeten historischen Arbeiterviertel Böhmisch-Rixdorf. In unmittelbarer Umgebung: Cafés, Bars, Einkaufsmöglichkeiten, Neuköllner Oper, Kinos, zahlreiche Galerien, Volkspark Hasenheide und Tempelhofer Feld. Auf Wunsch Stadtführungen mit sachkundigen Stadtführern. Hierzu beraten wir Sie gern. Für Gruppen bis 8 Personen bieten wir Führungen für 20 Euro an, jede weitere Person 2 Euro. Die Nutzung des Berliner Nahverkehrs kostet extra.	5	1.1%
we are a guesthouse and not a private appartment. every room/appartment with its own entrance and bathroom.	4	0.9%
Schön eingerichtete 3-Zimmerwohnung mit 2 Schlafzimmern und Internetanschluss . Aus der 10. Etg eines Mehrfamilienhauses gibt es einen herrlichen Ausblick auf den Fernsehturm und den Alexanderplatz in der Nähe.	4	0.9%
Large room that can accommodate up to 6 people. It has 3 bunk beds and is very suitable for small groups. The spacious bathroom is for multiple rooms.	2	0.4%
Im sanierten Seitenflügel eines Altbau-Wohnhauses im Friedrichshainer Kiez, mit kurzen Wegen zur S-Bahn, DB-Bahn, Flughafen, zum Alexanderplatz, Park oder zur Spree	2	0.4%
Exceptional guestroom in the back of the legendary Berlin Kinomuseum. We offer one single and one double room, regulary Salon Evenings and Film Screenings. Truly unique in Berlin!	2	0.4%
Our apt (90sqm / 1.000sqft) is in a 1893 historical building with big bedrooms, 2 bathrooms, kitchen and living room Centrally located in Prenzlauer Berg, Berlin's most beautiful area, in a quiet street w/ nice restaurants, cafés and lots of green!	1	0.2%
Wir freuen uns Sie in Berlin begrüßen zu dürfen Die Geschäftsleitung	1	0.2%
In the heart of Berlin Kreuzberg: between Viktoriapark und Tempelhofer-field. Enjoy the multi cultural Bergmannstraßen-Kiez. My bright and comfortable apartment offers the perfect starting point to discover Berlin.	1	0.2%
A large and comfortable 2 room apartment with huge windows, street-side balcony, high ceiling and wooden floor. Un-renovated and furnished in the typical Berlin half vintage, half street-style. One half is for you, one half is for my home office lounge or if you want the whole pad, just ask, I am flexible. Additional 35€ cleaning fee added for whole apartment bookings. Details below, read on :) All humans are welcome here.	1	0.2%
Other values (274)	274	60.5%
(Missing)	156	34.4%

Max length	500
Mean length	163.7792494
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

thumbnail_url
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

transit
Categorical

Distinct count	265
Unique (%)	58.5%
Missing (%)	36.2%
Missing (n)	164

The connection to the public transport network (metro, urban railway, bus, tram) and the central location between Prenzlauer Berg and the Spree guarantee an ideal place to find us easily and to explore Berlin and its surroundings afterwords. Urban railway / S-Bahn: Warschauer Straße (S3, S5, S7, S75): 5 min Metro / U-Bahn: Warschauer Straße (U1): 6 min Frankfurter Tor (U5): 12 min Tram: Warschauer- / Revaler Straße (M10, M13): 4 min Bus: Helsingforser Platz (347, N1): 3 min (all times are by walking)	8
Zwei U-Bahnhöfe in der Nähe, dabei direkte Verbindung zum Alexanderplatz. Kostenlose Parkmöglichkeiten in unmittelbarer Umgebung.	5
Der S-Bahnhof "Beusselstr" ist zu Fuß 5 Minuten entfernt, mit der dort fahrenden Ringbahn kommt man schnell überall hin. Ebenfalls am S-Bahnhof fahren mehrere Buslinien, u. a. zum Hauptbahnhof, zum Flughafen Tegel, zum Alexanderplatz... Die nächste U-Bahnstation "Birkenstrasse" ist zu Fuß ca. 15 Minuten entfernt, man kann aber auch mit der S-Bahn fahren und umsteigen.	3
Other values (261)	273
(Missing)	164

Toggle details

Common values
Composition

Value	Count	Frequency (%)
The connection to the public transport network (metro, urban railway, bus, tram) and the central location between Prenzlauer Berg and the Spree guarantee an ideal place to find us easily and to explore Berlin and its surroundings afterwords. Urban railway / S-Bahn: Warschauer Straße (S3, S5, S7, S75): 5 min Metro / U-Bahn: Warschauer Straße (U1): 6 min Frankfurter Tor (U5): 12 min Tram: Warschauer- / Revaler Straße (M10, M13): 4 min Bus: Helsingforser Platz (347, N1): 3 min (all times are by walking)	8	1.8%
Zwei U-Bahnhöfe in der Nähe, dabei direkte Verbindung zum Alexanderplatz. Kostenlose Parkmöglichkeiten in unmittelbarer Umgebung.	5	1.1%
Der S-Bahnhof "Beusselstr" ist zu Fuß 5 Minuten entfernt, mit der dort fahrenden Ringbahn kommt man schnell überall hin. Ebenfalls am S-Bahnhof fahren mehrere Buslinien, u. a. zum Hauptbahnhof, zum Flughafen Tegel, zum Alexanderplatz... Die nächste U-Bahnstation "Birkenstrasse" ist zu Fuß ca. 15 Minuten entfernt, man kann aber auch mit der S-Bahn fahren und umsteigen.	3	0.7%
Der Bahnhof Ostkreuz ist nur 7 Gehminuten entfernt, der eine schlelle Verbindung zu den Flughäfen, Bahnhof und ins ganze Stadtgebiet ermöglicht.	3	0.7%
Close to all public transport connections (a few minutes walk) Underground line U6 Overground train - Friedrichstrasse , Nordbahnhof & Hauptbahnhof Tram connections - Friedrichstrasse & Nordbahnhof	2	0.4%
The train and tram station "Greifswalder Straße" is only 200m away and will take you directly to: * the Alexander Platz - 10 minutes. * the Museum Island with the famous Berliner Dom, Hackescher Markt - 15 minutes * Schönefeld Airport (SFX) - 35 minutes Or with one change of trains to * Tegel Airport (TXL) - 25 minutes * the Brandenburg Gate - 20 minutes * Checkpoint Charlie - 25 minutes The M10 tram station is 700m away and will take you directly to the East Side Gallery (15 minutes)	2	0.4%
Durch die nahe gelegene U-Bahn-Station Nollendorfplatz ist das Appartement exzellent an das Berliner Nahverkehrssystem (BVG) angebunden. An diesem zentralen Verkehrsknotenpunkt kreuzen sich die U-Bahnlinien U1, U2, U3 und U4. Außerdem lässt sich von hier aus die Berliner City binnen weniger Minuten über die Busverbindungen M19, 106 und 187 erschließen. Auch die Nachtbusverbindungen N1, N2 und N26 treffen sich genau hier. Die Parksituation ist für Berliner Innenstadtverhältnisse recht entspannt. Die Zone mit den zu bezahlenden Parkplätzen endet etwa 100 Meter weiter vorher, so dass sich in der unmittelbaren Nähe immer leicht ein Parkplatz finden sollte.	2	0.4%
Metro U1 Schlesisches Tor, S-Bahn Warschauerstr., Bus No. 265 Falckensteinstr.	2	0.4%
Often I have a spare monthly ticket so if you want you can have for for a day. I ask for EUr 5.00 per day. The normal price for a day ticket is EUr 6.90 so I guess its a good deal. The closest metro (U-Bahn) is laterally less than 1 minute walk. from here you can easily go from East to West Berlin. 1 metro stop away is POTSDAMER PLATZ, the former Down Town before the wall existed, from there you can take trains to North or South if you want to go to the Concentration Camp or to Potsdam (the City of Emperors) check it out before you come. Also bus line 200 and night bus line N2 stops at the door step. Night bus line N6 stops 2 block from here on Friedrichstrasse at Statmitte Station.	2	0.4%
Die M 68 Straßenbahn ( eine 100 Jahre alte Linie ) fährt Sie am Strandbad Grünau bis zur S - Bahn. Von dort haben Sie 2 Verbindungen zur City	2	0.4%
Other values (254)	258	57.0%
(Missing)	164	36.2%

Max length	1000
Mean length	182.8432671
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

weekly_price
Categorical

Distinct count	106
Unique (%)	23.4%
Missing (%)	40.6%
Missing (n)	184

$300.00	16
$350.00	13
$200.00	12
Other values (102)	228
(Missing)	184

Toggle details

Common values
Composition

Value	Count	Frequency (%)
$300.00	16	3.5%
$350.00	13	2.9%
$200.00	12	2.6%
$500.00	10	2.2%
$420.00	10	2.2%
$450.00	8	1.8%
$250.00	7	1.5%
$260.00	6	1.3%
$600.00	6	1.3%
$340.00	6	1.3%
Other values (95)	175	38.6%
(Missing)	184	40.6%

Max length	9
Mean length	5.397350993
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

xl_picture_url
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

zipcode
Categorical

Distinct count	107
Unique (%)	23.6%
Missing (%)	0.7%
Missing (n)	3

10437	28
10119	25
10405	23
Other values (103)	374

Toggle details

Common values
Composition

Value	Count	Frequency (%)
10437	28	6.2%
10119	25	5.5%
10405	23	5.1%
10115	21	4.6%
10435	21	4.6%
10997	19	4.2%
10245	18	4.0%
10243	14	3.1%
10247	12	2.6%
10117	12	2.6%
Other values (96)	257	56.7%

Max length	11
Mean length	5
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

First rows

	access	accommodates	amenities	availability_30	availability_365	availability_60	availability_90	bathrooms	bed_type	bedrooms	beds	calculated_host_listings_count	calendar_last_scraped	calendar_updated	cancellation_policy	city	cleaning_fee	country	country_code	description	experiences_offered	extra_people	first_review	guests_included	has_availability	host_about	host_acceptance_rate	host_has_profile_pic	host_id	host_identity_verified	host_is_superhost	host_listings_count	host_location	host_name	host_neighbourhood	host_picture_url	host_response_rate	host_response_time	host_since	host_thumbnail_url	host_total_listings_count	host_url	host_verifications	house_rules	id	instant_bookable	interaction	is_business_travel_ready	is_location_exact	jurisdiction_names	last_review	last_scraped	latitude	license	listing_url	longitude	market	maximum_nights	medium_url	minimum_nights	monthly_price	name	neighborhood_overview	neighbourhood	neighbourhood_cleansed	neighbourhood_group_cleansed	notes	number_of_reviews	picture_url	price	property_type	require_guest_phone_verification	require_guest_profile_picture	requires_license	review_scores_accuracy	review_scores_checkin	review_scores_cleanliness	review_scores_communication	review_scores_location	review_scores_rating	review_scores_value	reviews_per_month	room_type	scrape_id	security_deposit	smart_location	space	square_feet	state	street	summary	thumbnail_url	transit	weekly_price	xl_picture_url	zipcode
0	Simple kitchen/cooking, refrigerator, microwav...	3	{TV,"Cable TV",Wifi,Kitchen,Gym,Heating,"Famil...	0	141	21	51	1.0	Real Bed	1.0	2.0	4	2018-11-07	3 months ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	Great location! 30 of 75 sq meters. This wood...	none	$28.00	2016-04-11	1	t	Believe in sharing economy.	NaN	t	2217	t	t	4	Key Biscayne, Florida, United States	Ian	Mitte	https://a0.muscache.com/im/pictures/21428a22-4...	96%	within an hour	2008-08-18	https://a0.muscache.com/im/pictures/21428a22-4...	4	https://www.airbnb.com/users/show/2217	['email', 'phone', 'reviews', 'jumio', 'offlin...	No parties No events No pets No smoking, not e...	2015	f	Always available	f	f	NaN	2018-10-28	2018-11-07	52.534537	NaN	https://www.airbnb.com/rooms/2015	13.402557	Berlin	1125	NaN	4	NaN	Berlin-Mitte Value! Quiet courtyard/very central	It is located in the former East Berlin area o...	Mitte	Brunnenstr. Süd	Mitte	This is my home, not a hotel. I rent out occas...	118	https://a0.muscache.com/im/pictures/260fd609-7...	$60.00	Guesthouse	f	f	t	10.0	10.0	9.0	10.0	10.0	93.0	9.0	3.76	Entire home/apt	20181107122246	$200.00	Berlin, Germany	A+++ location! This „Einliegerwohnung“ is an e...	NaN	Berlin	Berlin, Berlin, Germany	Great location! 30 of 75 sq meters. This wood...	NaN	Close to U-Bahn U8 and U2 (metro), Trams M12, ...	NaN	NaN	10119
1	Außer deinem Zimmer kannst du noch die Küche u...	2	{Wifi,Kitchen,Elevator,Heating,Washer,Essentia...	0	0	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	7 weeks ago	flexible	Berlin	$0.00	Germany	DE	In the summertime we are spending most of our ...	none	$0.00	2018-07-04	1	t	Living with my wife in Berlin. Like travellin...	NaN	t	2986	t	f	1	Berlin, Berlin, Germany	Michael	Prenzlauer Berg	https://a0.muscache.com/im/pictures/50434955-1...	NaN	NaN	2008-09-16	https://a0.muscache.com/im/pictures/50434955-1...	1	https://www.airbnb.com/users/show/2986	['email', 'phone', 'reviews', 'jumio', 'govern...	NaN	2695	f	NaN	f	t	NaN	2018-10-01	2018-11-07	52.548513	NaN	https://www.airbnb.com/rooms/2695	13.404553	Berlin	40	NaN	2	NaN	Prenzlauer Berg close to Mauerpark	NaN	NaN	Prenzlauer Berg Nordwest	Pankow	NaN	6	https://a0.muscache.com/im/pictures/97d4f6e8-1...	$17.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	100.0	10.0	1.42	Private room	20181107122246	$0.00	Berlin, Germany	In the summertime we are spending most of our ...	NaN	Berlin	Berlin, Berlin, Germany	NaN	NaN	Within walking distance you'll find the S-Bahn...	NaN	NaN	10437
2	The apartment will be entirely yours. We are c...	4	{Internet,Wifi,Kitchen,"Buzzer/wireless interc...	0	220	0	0	1.0	Real Bed	1.0	2.0	1	2018-11-07	a week ago	strict_14_with_grace_period	Berlin	$50.00	Germany	DE	This beautiful first floor apartment is situa...	none	$20.00	2009-06-20	2	t	We love to travel ourselves a lot and prefer t...	NaN	t	3718	t	f	1	Coledale, New South Wales, Australia	Britta	Prenzlauer Berg	https://a0.muscache.com/im/users/3718/profile_...	100%	within a day	2008-10-19	https://a0.muscache.com/im/users/3718/profile_...	1	https://www.airbnb.com/users/show/3718	['email', 'phone', 'facebook', 'reviews', 'man...	It’s a non smoking flat, which likes to be tre...	3176	t	Feel free to ask any questions prior to bookin...	f	t	NaN	2017-03-20	2018-11-07	52.534996	NaN	https://www.airbnb.com/rooms/3176	13.417579	Berlin	1125	NaN	62	$1,900.00	Fabulous Flat in great Location	The neighbourhood is famous for its variety of...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	We welcome FAMILIES and cater especially for y...	143	https://a0.muscache.com/im/pictures/243355/84a...	$90.00	Apartment	f	f	t	9.0	9.0	9.0	9.0	10.0	92.0	9.0	1.25	Entire home/apt	20181107122246	$200.00	Berlin, Germany	1st floor (68m2) apartment on Kollwitzplatz/ P...	720.0	Berlin	Berlin, Berlin, Germany	This beautiful first floor apartment is situa...	NaN	We are 5 min walk away from the tram M2, whic...	$520.00	NaN	10405
3	I do have a strictly non-smoker-flat. Keep th...	2	{Internet,Wifi,"Pets allowed","Pets live on th...	0	297	0	22	1.0	Pull-out Sofa	1.0	1.0	1	2018-11-07	4 weeks ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	First of all: I prefer short-notice bookings. ...	none	$18.00	2013-08-12	1	t	ENJOY EVERY DAY AS IF IT'S YOUR LAST!!! \r\n\r...	NaN	t	4108	t	f	1	Berlin, Berlin, Germany	Jana	Schöneberg	https://a0.muscache.com/im/pictures/user/b5938...	NaN	NaN	2008-11-07	https://a0.muscache.com/im/pictures/user/b5938...	1	https://www.airbnb.com/users/show/4108	['email', 'phone', 'reviews', 'jumio', 'govern...	House-Rules and Information ..............(deu...	3309	f	I'm working as a freelancing photographer. My ...	f	t	NaN	2018-08-16	2018-11-07	52.498855	NaN	https://www.airbnb.com/rooms/3309	13.349065	Berlin	360	NaN	5	$599.00	BerlinSpot Schöneberg near KaDeWe	My flat is in the middle of West-Berlin, direc...	Schöneberg	Schöneberg-Nord	Tempelhof - Schöneberg	The flat is a strictly non-smoking facility! A...	25	https://a0.muscache.com/im/pictures/29054294/b...	$26.00	Apartment	f	f	t	9.0	9.0	9.0	10.0	9.0	88.0	9.0	0.39	Private room	20181107122246	$250.00	Berlin, Germany	Your room is really big and has 26 sqm, is ver...	0.0	Berlin	Berlin, Berlin, Germany	First of all: I prefer short-notice bookings. ...	NaN	The public transportation is excellent: Severa...	$175.00	NaN	10777
4	The guests have access to the bathroom, a smal...	2	{Wifi,Heating,"Family/kid friendly",Essentials...	15	26	26	26	1.0	Real Bed	1.0	2.0	1	2018-11-07	3 days ago	moderate	Berlin	$0.00	Germany	DE	Cozy and large room in the beautiful district ...	none	$24.00	2009-08-18	1	t	I'm a creative person, adventurer, and travele...	NaN	t	17391	t	t	1	Berlin, Berlin, Germany	Bright	Prenzlauer Berg	https://a0.muscache.com/im/pictures/user/48c3d...	100%	within an hour	2009-05-16	https://a0.muscache.com/im/pictures/user/48c3d...	1	https://www.airbnb.com/users/show/17391	['email', 'phone', 'reviews', 'jumio', 'govern...	Please take good care of everything during you...	7071	f	I am glad if I can give you advice or help as ...	f	t	NaN	2018-11-04	2018-11-07	52.543157	NaN	https://www.airbnb.com/rooms/7071	13.415091	Berlin	10	NaN	2	NaN	BrightRoom with sunny greenview!	Great neighborhood with plenty of Cafés, Baker...	Prenzlauer Berg	Helmholtzplatz	Pankow	I hope you enjoy your stay to the fullest! Ple...	197	https://a0.muscache.com/im/pictures/21278/32a1...	$42.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	96.0	9.0	1.75	Private room	20181107122246	$0.00	Berlin, Germany	The BrightRoom is an approx. 20 sqm (215ft²), ...	NaN	Berlin	Berlin, Berlin, Germany	Cozy and large room in the beautiful district ...	NaN	Best access to other parts of the city via pub...	NaN	NaN	10437
5	All amenities shared - nothing off limits	7	{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid par...	0	137	7	7	2.5	Real Bed	4.0	7.0	1	2018-11-07	2 weeks ago	strict_14_with_grace_period	Berlin	$80.00	Germany	DE	4 bedroom with very large windows and outstand...	none	$10.00	2015-08-09	5	t	Born in Munich - lives in and loves Berlin. Wo...	NaN	t	33852	t	f	1	Berlin, Berlin, Germany	Philipp	Prenzlauer Berg	https://a0.muscache.com/im/users/33852/profile...	100%	within a few hours	2009-08-25	https://a0.muscache.com/im/users/33852/profile...	1	https://www.airbnb.com/users/show/33852	['email', 'phone', 'facebook', 'reviews', 'jum...	NaN	9991	f	Guests will have the whole apartment to themse...	f	f	NaN	2018-07-23	2018-11-07	52.533031	03/Z/RA/003410-18	https://www.airbnb.com/rooms/9991	13.416047	Berlin	14	NaN	6	NaN	Geourgeous flat - outstanding views	Prenzlauer Berg is an amazing neighbourhood wh...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	6	https://a0.muscache.com/im/pictures/42799131/5...	$180.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	100.0	10.0	0.15	Entire home/apt	20181107122246	$400.00	Berlin, Germany	THE APPARTMENT - 4 bedroom (US, Germany: 5 roo...	NaN	Berlin	Berlin, Berlin, Germany	4 bedroom with very large windows and outstand...	NaN	Excellent location regarding public transport ...	$650.00	NaN	10405
6	NaN	2	{TV,Internet,Wifi,Kitchen,"Buzzer/wireless int...	0	129	0	0	1.0	Real Bed	0.0	1.0	3	2018-11-07	today	strict_14_with_grace_period	Berlin	$0.00	Germany	DE	The apartment is located on the upper second f...	none	$0.00	2010-06-29	1	t	From Berlin, Germany. Working at ‘Welcome Beyo...	NaN	t	55531	f	f	3	Berlin, Berlin, Germany	Chris + Oliver	Prenzlauer Berg	https://a0.muscache.com/im/users/55531/profile...	100%	within a day	2009-11-18	https://a0.muscache.com/im/users/55531/profile...	3	https://www.airbnb.com/users/show/55531	['email', 'phone', 'reviews', 'jumio', 'offlin...	No smoking, loud music or hosting parties at t...	14325	f	NaN	f	t	NaN	2018-11-01	2018-11-07	52.547846	NaN	https://www.airbnb.com/rooms/14325	13.405562	Berlin	1125	NaN	90	$820.00	Apartment in Prenzlauer Berg	NaN	Prenzlauer Berg	Prenzlauer Berg Nordwest	Pankow	NaN	23	https://a0.muscache.com/im/pictures/508703/249...	$70.00	Apartment	f	f	t	10.0	9.0	10.0	10.0	9.0	93.0	9.0	0.23	Entire home/apt	20181107122246	$500.00	Berlin, Germany	The apartment is located on the south-facing s...	NaN	Berlin	Berlin, Berlin, Germany	The apartment is located on the upper second f...	NaN	NaN	$420.00	NaN	10437
7	NaN	2	{TV,"Cable TV",Internet,Wifi,Kitchen,"Smoking ...	30	365	60	90	1.0	Real Bed	1.0	2.0	1	2018-11-07	never	strict_14_with_grace_period	Berlin	NaN	Germany	DE	Hello future guests! We want to rent our cute ...	none	$13.00	NaN	1	t	I'm uncomplicated, funny, curious and I love t...	NaN	t	59666	t	f	1	Berlin, Berlin, Germany	Melanie	Friedrichshain	https://a0.muscache.com/im/pictures/65266732-d...	NaN	NaN	2009-12-03	https://a0.muscache.com/im/pictures/65266732-d...	1	https://www.airbnb.com/users/show/59666	['email', 'phone', 'facebook', 'jumio', 'offli...	NaN	16401	f	NaN	f	t	NaN	NaN	2018-11-07	52.510514	NaN	https://www.airbnb.com/rooms/16401	13.457850	Berlin	52	NaN	30	NaN	APARTMENT TO RENT	NaN	Friedrichshain	Frankfurter Allee Süd FK	Friedrichshain-Kreuzberg	NaN	0	https://a0.muscache.com/im/pictures/4753854/99...	$120.00	Apartment	f	f	t	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Private room	20181107122246	NaN	Berlin, Germany	Hello future guests! We want to rent our cute ...	NaN	Berlin	Berlin, Berlin, Germany	NaN	NaN	NaN	NaN	NaN	10245
8	The guests use the whole apartment alone. Part...	5	{TV,Wifi,Kitchen,"Buzzer/wireless intercom",He...	0	159	0	0	1.0	Real Bed	1.0	3.0	2	2018-11-07	2 months ago	strict_14_with_grace_period	Berlin	$50.00	Germany	DE	Light and sunny 2-Room-turn of the century-fla...	none	$20.00	2010-06-04	2	t	Friendly and social. Likes to travel and enjoy...	NaN	t	64696	f	f	4	Santa Cruz, California, United States	Rene	Kreuzberg	https://a0.muscache.com/im/users/64696/profile...	100%	within a few hours	2009-12-20	https://a0.muscache.com/im/users/64696/profile...	4	https://www.airbnb.com/users/show/64696	['email', 'phone', 'facebook', 'reviews', 'kba']	1. No noise after 10 pm PLEASE. 2. Please do n...	16644	f	The guest determines how much interaction they...	f	t	NaN	2017-12-14	2018-11-07	52.504792	NaN	https://www.airbnb.com/rooms/16644	13.435102	Berlin	365	NaN	60	$1,440.00	In the Heart of Berlin - Kreuzberg	Our Part of Kreuzberg is just the best. Good v...	Kreuzberg	nördliche Luisenstadt	Friedrichshain-Kreuzberg	NaN	48	https://a0.muscache.com/im/pictures/73759174/e...	$90.00	Apartment	t	f	t	10.0	10.0	10.0	10.0	9.0	94.0	9.0	0.47	Entire home/apt	20181107122246	$500.00	Berlin, Germany	Rent in the heart of Berlin - Kreuzberg Newly ...	0.0	Berlin	Berlin, Berlin, Germany	Light and sunny 2-Room-turn of the century-fla...	NaN	Ostbahnhof is close so you can get here by tra...	$520.00	NaN	10997
9	The roof terrace and the kitchen can be used b...	2	{TV,Internet,Wifi,Kitchen,"Paid parking off pr...	8	42	18	42	1.0	Real Bed	1.0	1.0	1	2018-11-07	a week ago	strict_14_with_grace_period	Berlin	$18.00	Germany	DE	The 25 sqm room is located in the heart of Ber...	none	$26.00	2010-10-07	1	t	A Political journalist and well acquainted wit...	NaN	t	67590	t	t	1	Berlin, Berlin, Germany	Wolfram	Prenzlauer Berg	https://a0.muscache.com/im/pictures/user/a3d84...	100%	within an hour	2010-01-04	https://a0.muscache.com/im/pictures/user/a3d84...	1	https://www.airbnb.com/users/show/67590	['email', 'phone', 'facebook', 'reviews', 'kba']	No smoking in the room, but possible outside o...	17409	f	I have seen some parts of the world and not on...	f	t	NaN	2018-10-31	2018-11-07	52.529071	NaN	https://www.airbnb.com/rooms/17409	13.412843	Berlin	30	NaN	3	$955.00	Downtown Above The Roofs In Berlin	You are in the heart of the former East-Berlin...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	279	https://a0.muscache.com/im/pictures/9964850/c5...	$45.00	Condominium	f	f	t	10.0	10.0	10.0	10.0	10.0	96.0	10.0	2.83	Private room	20181107122246	$0.00	Berlin, Germany	A 25 sqm room in the heart of Berlin. Many pla...	NaN	Berlin	Berlin, Berlin, Germany	The 25 sqm room is located in the heart of Ber...	NaN	The subway is just a two minutes walk away, th...	$281.00	NaN	10405

Last rows

	access	accommodates	amenities	availability_30	availability_365	availability_60	availability_90	bathrooms	bed_type	bedrooms	beds	calculated_host_listings_count	calendar_last_scraped	calendar_updated	cancellation_policy	city	cleaning_fee	country	country_code	description	experiences_offered	extra_people	first_review	guests_included	has_availability	host_about	host_acceptance_rate	host_has_profile_pic	host_id	host_identity_verified	host_is_superhost	host_listings_count	host_location	host_name	host_neighbourhood	host_picture_url	host_response_rate	host_response_time	host_since	host_thumbnail_url	host_total_listings_count	host_url	host_verifications	house_rules	id	instant_bookable	interaction	is_business_travel_ready	is_location_exact	jurisdiction_names	last_review	last_scraped	latitude	license	listing_url	longitude	market	maximum_nights	medium_url	minimum_nights	monthly_price	name	neighborhood_overview	neighbourhood	neighbourhood_cleansed	neighbourhood_group_cleansed	notes	number_of_reviews	picture_url	price	property_type	require_guest_phone_verification	require_guest_profile_picture	requires_license	review_scores_accuracy	review_scores_checkin	review_scores_cleanliness	review_scores_communication	review_scores_location	review_scores_rating	review_scores_value	reviews_per_month	room_type	scrape_id	security_deposit	smart_location	space	square_feet	state	street	summary	thumbnail_url	transit	weekly_price	xl_picture_url	zipcode
443	NaN	2	{TV,Wifi,Kitchen,"Buzzer/wireless intercom",He...	0	155	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	2 weeks ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	From the 1st of May 2016: Due to a new legisla...	none	$19.00	2012-05-08	1	t	It is great to be host to friendly people from...	NaN	t	2236088	t	f	1	Berlin, Berlin, Germany	Ingo	Prenzlauer Berg	https://a0.muscache.com/im/users/2236088/profi...	50%	within a day	2012-04-27	https://a0.muscache.com/im/users/2236088/profi...	1	https://www.airbnb.com/users/show/2236088	['email', 'phone', 'reviews', 'kba']	Strictly no Smoking (except on the balcony) an...	450325	f	NaN	f	t	NaN	2018-07-08	2018-11-07	52.538508	NaN	https://www.airbnb.com/rooms/450325	13.406859	Berlin	1125	NaN	60	NaN	gorgeous old chocolate factory	The Schwedter Strasse is a great location to s...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	55	https://a0.muscache.com/im/pictures/9531486/ae...	$109.00	Loft	t	t	t	10.0	10.0	10.0	10.0	10.0	99.0	10.0	0.69	Entire home/apt	20181107122246	$1,000.00	Berlin, Germany	From the 1st of May 2016: Due to a new legisla...	592.0	Berlin	Berlin, Berlin, Germany	NaN	NaN	There are four tube stations nearby: Eberswald...	NaN	NaN	10435
444	private parking space in the house. terrace, b...	5	{TV,Internet,Wifi,"Wheelchair accessible",Kitc...	0	252	0	0	2.0	Real Bed	3.0	5.0	1	2018-11-07	4 months ago	strict_14_with_grace_period	Berlin	$60.00	Germany	DE	beautiful 130 m2 loft-like apartment on the fo...	none	$25.00	2013-07-06	1	t	I love traveling and I love beautiful homes. W...	NaN	t	2246564	t	f	1	Berlin, Berlin, Germany	Kim	Mitte	https://a0.muscache.com/im/users/2246564/profi...	NaN	NaN	2012-04-29	https://a0.muscache.com/im/users/2246564/profi...	1	https://www.airbnb.com/users/show/2246564	['email', 'phone', 'reviews', 'jumio', 'govern...	during the summer, it would be great if our pl...	452164	f	I'll be answering all questions via email thou...	f	t	NaN	2017-04-13	2018-11-07	52.531104	NaN	https://www.airbnb.com/rooms/452164	13.388507	Berlin	31	NaN	5	NaN	In the middle of Mitte and green!	very quiet neighborhood, but close to all shop...	Mitte	Brunnenstr. Süd	Mitte	NaN	6	https://a0.muscache.com/im/pictures/17689959/e...	$130.00	Apartment	f	f	t	10.0	10.0	9.0	10.0	10.0	100.0	9.0	0.09	Entire home/apt	20181107122246	$250.00	Berlin, Germany	Wonderful big 130 qm apartment in Mitte or so ...	1399.0	Berlin	Berlin, Berlin, Germany	beautiful 130 m2 loft-like apartment on the fo...	NaN	Trainstation Nordbahnhof 300m from our door. G...	NaN	NaN	10115
445	NaN	2	{Internet,Wifi,Kitchen,Heating,"Family/kid fri...	22	339	40	70	1.0	Real Bed	1.0	1.0	1	2018-11-07	1 week ago	moderate	Berlin	$40.00	Germany	DE	We offer a charming converted cottage in a hug...	none	$30.00	2012-08-29	2	t	I am a journalist and mother of wonderful twin...	NaN	t	1981166	f	f	1	Berlin, Berlin, Germany	Ilka	Zehlendorf	https://a0.muscache.com/im/users/1981166/profi...	NaN	NaN	2012-03-21	https://a0.muscache.com/im/users/1981166/profi...	1	https://www.airbnb.com/users/show/1981166	['email', 'phone', 'facebook', 'reviews']	Gäste nur nach Absprache. Die Privatsphäre des...	456839	f	NaN	f	f	NaN	2018-10-05	2018-11-07	52.437196	NaN	https://www.airbnb.com/rooms/456839	13.242451	Berlin	90	NaN	2	$1,800.00	Charming converted cottage	NaN	Zehlendorf	Zehlendorf Nord	Steglitz - Zehlendorf	NaN	13	https://a0.muscache.com/im/pictures/5654349/5a...	$90.00	House	f	f	t	10.0	10.0	10.0	10.0	10.0	100.0	10.0	0.17	Entire home/apt	20181107122246	NaN	Berlin, Germany	We offer a charming converted cottage in a hug...	0.0	Berlin	Berlin, Berlin, Germany	NaN	NaN	NaN	$590.00	NaN	14163
446	Access to the whole apartment.	4	{TV,Internet,Wifi,Kitchen,"Paid parking off pr...	6	254	13	34	1.0	Real Bed	1.0	1.0	1	2018-11-07	3 days ago	strict_14_with_grace_period	Berlin	$30.00	Germany	DE	Comfortable and cosy Apartment in a very nice ...	none	$15.00	2012-08-04	2	t	Es macht Spass Gastgeber hier in Berlin zu sei...	NaN	t	2271792	t	t	1	Berlin, Berlin, Germany	Stefan	Kreuzberg	https://a0.muscache.com/im/users/2271792/profi...	NaN	NaN	2012-05-02	https://a0.muscache.com/im/users/2271792/profi...	1	https://www.airbnb.com/users/show/2271792	['email', 'phone', 'facebook', 'reviews', 'jum...	This is a no smoking apartment.	456902	f	We live next door to the flat. So if you´ve go...	f	t	NaN	2018-11-01	2018-11-07	52.492952	NaN	https://www.airbnb.com/rooms/456902	13.412858	Berlin	1125	NaN	2	$1,400.00	Maisonette Apartment in Kreuzberg	Who wants to experience Berlin is here in the ...	Kreuzberg	Tempelhofer Vorstadt	Friedrichshain-Kreuzberg	The apartment is perfect for couples, a good p...	211	https://a0.muscache.com/im/pictures/5339551/77...	$83.00	Loft	f	f	t	10.0	10.0	10.0	10.0	10.0	98.0	10.0	2.77	Entire home/apt	20181107122246	NaN	Berlin, Germany	Welcome to the center of Berlin. Since January...	NaN	Berlin	Berlin, Berlin, Germany	Comfortable and cosy Apartment in a very nice ...	NaN	U7 (to Kurfürstendamm/City West): U-Südstern 5...	$483.00	NaN	10967
447	Unseren schönen Garten dürfen Sie gemeinsam mi...	4	{TV,Wifi,Kitchen,"Pets allowed","Pets live on ...	25	352	47	77	1.0	Real Bed	2.0	2.0	1	2018-11-07	yesterday	flexible	Berlin	$40.00	Germany	DE	Rest and relaxation in Berlin? This is, like I...	none	$0.00	2012-08-30	4	t	Ich freue mich darauf Euch in meiner Wohnung z...	NaN	t	978210	f	f	1	Berlin, Berlin, Germany	Hannelore	Karow	https://a0.muscache.com/im/users/978210/profil...	100%	within an hour	2011-08-16	https://a0.muscache.com/im/users/978210/profil...	1	https://www.airbnb.com/users/show/978210	['email', 'phone', 'reviews']	Wir erwarten angenehme Gäste . Keine Partyfan...	458586	f	Ich bin jederzeit für Sie ansprechbar. Die Woh...	f	t	NaN	2018-11-03	2018-11-07	52.603266	NaN	https://www.airbnb.com/rooms/458586	13.481914	Berlin	30	NaN	2	$1,500.00	You are looking for peace and relax	Unsere Umgebung ist ein ländliches Umfeld in ...	Karow	Karow	Pankow	Bitte beachten Sie: Rauchen nur in der Veranda...	77	https://a0.muscache.com/im/pictures/34865559/3...	$70.00	Apartment	t	t	t	10.0	10.0	10.0	10.0	9.0	94.0	10.0	1.02	Entire home/apt	20181107122246	$200.00	Berlin, Germany	Rest and relaxation in Berlin? This is, like I...	NaN	Berlin	Berlin, Berlin, Germany	Berlin ist wunderschön.Das bestätigen unsere G...	NaN	Busse, S-Bahn, Fernbahn auch ins Umland. Park...	$440.00	NaN	13125
448	Spacious and sunny room with double bed 140 x ...	2	{Internet,Kitchen,"Pets allowed",Elevator,"Buz...	0	0	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	11 months ago	moderate	Berlin	$80.00	Germany	DE	In the heart of Berlin Kreuzberg: between Vikt...	none	$20.00	2012-06-04	1	t	Hallo, \r\nich freue mich über interessante Gä...	NaN	t	2280531	f	f	2	Berlin, Berlin, Germany	Cornelia	Kreuzberg	https://a0.muscache.com/im/pictures/9296d406-c...	NaN	NaN	2012-05-03	https://a0.muscache.com/im/pictures/9296d406-c...	2	https://www.airbnb.com/users/show/2280531	['email', 'phone', 'facebook', 'reviews']	Our neighbours are very nice and friendly. Ple...	458608	t	NaN	f	t	NaN	2018-01-31	2018-11-07	52.486873	NaN	https://www.airbnb.com/rooms/458608	13.386211	Berlin	75	NaN	2	NaN	bright apartment in Berlin Kreuzberg	NaN	Kreuzberg	Tempelhofer Vorstadt	Friedrichshain-Kreuzberg	Ich habe 2 freundliche Katzen, die aber nicht ...	14	https://a0.muscache.com/im/pictures/5443010/c8...	$60.00	Apartment	f	f	t	10.0	10.0	9.0	10.0	10.0	98.0	10.0	0.18	Entire home/apt	20181107122246	$500.00	Berlin, Germany	This great 3 room apartment is located near th...	NaN	Berlin	Berlin, Berlin, Germany	In the heart of Berlin Kreuzberg: between Vikt...	NaN	U6 (Flughafen Tegel), U7 (Flughafen Schönefeld)	NaN	NaN	10965
449	NaN	5	{TV,"Cable TV",Internet,Wifi,Kitchen,"Buzzer/w...	0	5	5	5	1.5	Real Bed	3.0	5.0	2	2018-11-07	3 weeks ago	strict_14_with_grace_period	Berlin	NaN	Germany	DE	4 room apartment (2nd floor, 120m²): 3 BR, hu...	none	$0.00	2012-07-11	1	t	-	NaN	t	2281237	f	f	2	Berlin, Berlin, Germany	Antje	Prenzlauer Berg	https://a0.muscache.com/im/users/2281237/profi...	100%	within a day	2012-05-03	https://a0.muscache.com/im/users/2281237/profi...	2	https://www.airbnb.com/users/show/2281237	['email', 'phone', 'reviews']	NaN	458800	f	We are happy to offer suggestions for activiti...	f	t	NaN	2018-10-29	2018-11-07	52.540408	NaN	https://www.airbnb.com/rooms/458800	13.421441	Berlin	7	NaN	2	NaN	Beautiful 3BR, Excellent location	Der schönste Kiez Berlins	Prenzlauer Berg	Helmholtzplatz	Pankow	NaN	10	https://a0.muscache.com/im/pictures/1af74bc1-b...	$209.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	89.0	9.0	0.13	Entire home/apt	20181107122246	NaN	Berlin, Germany	We are subletting our private apartment during...	1238.0	Berlin	Berlin, Berlin, Germany	4 room apartment (2nd floor, 120m²): 3 BR, hu...	NaN	Sie erreichen die Tram und U Bahn in wenigen M...	$1,100.00	NaN	10437
450	NaN	2	{TV,Internet,Wifi,Kitchen,"Pets allowed",Eleva...	0	0	0	0	1.0	Real Bed	1.0	1.0	1	2018-11-07	2 months ago	strict_14_with_grace_period	Berlin	$60.00	Germany	DE	- 90 m² / 970 square feet right at the edge of...	none	$0.00	2012-05-22	2	t	Berlin based	NaN	t	311022	t	f	1	Berlin, Berlin, Germany	Antonia	Prenzlauer Berg	https://a0.muscache.com/im/users/311022/profil...	100%	within a few hours	2010-12-06	https://a0.muscache.com/im/users/311022/profil...	1	https://www.airbnb.com/users/show/311022	['email', 'phone', 'reviews', 'jumio', 'govern...	NaN	462459	f	NaN	f	t	NaN	2018-05-31	2018-11-07	52.532849	NaN	https://www.airbnb.com/rooms/462459	13.419732	Berlin	365	NaN	4	NaN	COOL BERLIN MITTE FLAT	NaN	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	9	https://a0.muscache.com/im/pictures/18033618/1...	$70.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	9.0	95.0	9.0	0.11	Entire home/apt	20181107122246	$350.00	Berlin, Germany	- 90 m² / 970 square feet right at the edge of...	NaN	Berlin	Berlin, Berlin, Germany	NaN	NaN	- right in front of the door the tram M2 is ru...	NaN	NaN	10405
451	You have your own private room and we share ba...	2	{Internet,Wifi,Kitchen,"Free street parking","...	7	18	11	18	1.0	Real Bed	1.0	1.0	1	2018-11-07	6 days ago	moderate	Berlin	NaN	Germany	DE	this is a real berlin experience /// I’m offe...	none	$30.00	2012-05-15	1	t	I am a vegetarian and I am into yoga\r\nand lo...	NaN	t	2266593	t	f	1	Berlin, Berlin, Germany	Gudrun	Kreuzberg	https://a0.muscache.com/im/users/2266593/profi...	100%	within a few hours	2012-05-01	https://a0.muscache.com/im/users/2266593/profi...	1	https://www.airbnb.com/users/show/2266593	['email', 'phone', 'facebook', 'reviews', 'jum...	while it's of course totally cool for you to e...	464324	f	If you have any questions just let me know I'd...	f	t	NaN	2018-10-29	2018-11-07	52.487942	NaN	https://www.airbnb.com/rooms/464324	13.375042	Berlin	120	NaN	3	$700.00	spacious room in light-flooded classy apartment	Location ///////////// from my apartment you o...	Kreuzberg	Tempelhofer Vorstadt	Friedrichshain-Kreuzberg	if you plan to stay longer just send me a note...	27	https://a0.muscache.com/im/pictures/100124170/...	$44.00	Apartment	f	f	t	10.0	10.0	10.0	10.0	10.0	99.0	9.0	0.34	Private room	20181107122246	NaN	Berlin, Germany	this is a real berlin experience /// I’m offe...	323.0	Berlin	Berlin, Berlin, Germany	NaN	NaN	get directions on the bvg.de website • the nex...	$259.00	NaN	10965
452	You are able to use free wifi. The kitchen, ba...	2	{Internet,Wifi,Kitchen,"Buzzer/wireless interc...	0	0	0	0	1.5	Real Bed	1.0	2.0	1	2018-11-07	8 months ago	strict_14_with_grace_period	Berlin	$35.00	Germany	DE	50-sqm part of my beautiful light non-smoking ...	none	$12.00	2015-05-04	1	t	I am a real Berliner, born and raised in Berli...	NaN	t	2017884	t	f	1	Berlin, Berlin, Germany	Claudia	Mitte	https://a0.muscache.com/im/pictures/user/9bdd4...	NaN	NaN	2012-03-27	https://a0.muscache.com/im/pictures/user/9bdd4...	1	https://www.airbnb.com/users/show/2017884	['email', 'phone', 'facebook', 'reviews', 'kba...	Looking for friendly care taking people, no pa...	466983	t	Da ich eine echte Berlinerin bin, erzähle ich ...	f	f	NaN	2018-04-01	2018-11-07	52.529863	NaN	https://www.airbnb.com/rooms/466983	13.410079	Berlin	60	NaN	3	$1,200.00	beautiful light room in 100qm place	Tolle Geschäfte, Restaurants, Bars, sowie Thea...	Prenzlauer Berg	Prenzlauer Berg Südwest	Pankow	NaN	75	https://a0.muscache.com/im/pictures/12089103/6...	$34.00	Apartment	f	f	t	10.0	9.0	9.0	9.0	10.0	92.0	9.0	1.75	Private room	20181107122246	$250.00	Berlin, Germany	I am renting 50-sqm, one big room 25qm and 25q...	269.0	Berlin	Berlin, Berlin, Germany	50-sqm part of my beautiful light non-smoking ...	NaN	Walking Distances: - Rosenthaler Platz: 2 Minu...	$350.00	NaN	10119

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows